Thank you so much Lynda. This is excellent. You have provided me with TWO solutions with your method. The first is selecting valid dimension members from a parameter but, with a few tweaks, I now also have the ability to do the reverse which works fantastically with Row Level Security (RLS) where the dimension members available are dynamically different, dependant on the users security permissions. The latter solution needed to have all options SELECTED by default and dependant on options available with RLS. Selecting a DIM member would REMOVE it from the table. Lastly I needed to have a means to RESET back to default ALL. I was able to achieve all of this by: Alteration to Lynda's model: 1. Reversing the sht:Table [c.Segment T|F] filiter from TRUE to FALSE 2. Reverse [c.Segment T|F] colour segment so TRUE = White and FALSE = Orange Additional steps for RESET button: 3. Add sht: RESET BUTTON. Using an icon shape and a text label with a blank value. 4. Add Dashboard Parameter Action RESET to clear parameter value when selecting the RESET button sheet in order to re-populate ALL Dimension members. Expansion of UI/UX - Functionality I will add, after being inspired by Lynda and Luke's original models. 5. Dropdown menu to show/hide multi param menu. 6. Add search for wildcard member using dedicated parameter and sheet. 7. Add wildcard member to concatenated string using dashboard parameter action Whilst your technique has helped me with my own models, coupled with the ability to expand/contract several specific menus using parameters, I am also getting closer to Luke Stanke's Experimental model 'menu' demo'd just before Christmas. So, thank you so much for sharing such an excellent and powerful technique.

@marievazelakis7553

20 күн бұрын

Hey Paul the above was helpful! I had a quick question that you may be able to answer. I’m doing this with IDs like 1234 and so contains function is pulling in 1234 and 12345 IDs, is there a way to change the Parameter action to = instead of contains? Or what would I need to do?

Absolute legend!! What I needed

This is amazing! Thanks for sharing! I can vaguely understand the logic behind this multi-selector, but it still bothers me why the calculated field "Param Action" as source field would push the desired values to the parameter at each click, since "Param Action" field begins with a list of segments (because the parameter was NULL to start). Any further readings that I can refer to on the relationships among source field, user action and parameter (especially when there is a loop...)? Thx!

Great tips. The only thing is I'm not sure of a way to keep the parameter list from snapping back up to the top when you select/deselect a parameter item

I also wanted to show all items when nothing was selected ( My list is a long list of user names). So I added this to my True False calculation. IF [Segment Parameter] = " " THEN True ELSE CONTAINS([Segment Parameter],[Segment]) END One issue is this makes it so I can't unselect a record once It's been selected. I can however show the parameter in the dashboard and clearing it then shows all items. It works, but anyone know how I could unselect the circles after selecting them?

What if the parameter list is a calculated field of 3x measures (so not a dimension like Segment)?

This is great, I have been looking for something like this and found the perfect solution. Is there a way to do a "select all" and "clear" selection with this ? Because if the list goes long then its hard to do those operations by clicking on each.

@paulwyatt8523

Жыл бұрын

Hi Ananth. Did you resolve this as it sounds as though you wanted the same behaviour as I needed? If that is the case, here is the alteration I made to Lynda's solution 1. Change the sht:Table [c.Segment T|F] filter from TRUE to FALSE. 2. Reverse the colour setting on the sht:Parameter. Once done, you may want to add another sheet which can be used as a button to reset the p.Segment parameter to blank, resetting the parameter to ALL.

Thank you for this. I have an error where if multiple fields starts with the same name, the selection works for all of them, eventhough the name is not exactly the same. For example, if I have two areas that begins with North, the selection will work on North East and North West, although I am just selecting North East. Is there a way to fix this?

Is it possible to do this with measure names? Or hide measure names filter on dashboard based on a parameter?

@primisole123

7 ай бұрын

Bump I am also interested in this! I have customarily used the Measure Names filter directly to show/exclude metrics in a sheet, but the problem is when I have many sheets in the same dashboard and I want to show/exclude metrics for each sheet but not include ALL used metrics in each filter.

very nice ! :-)

I'm getting an error in the Replace() clause: "Replace is not available on non-aggregates for this datasource

Hi Lynda it’s good video Multi selection in parameter but I have one requirement to do multi column selection when we choose multiple columns then cross tab get populate in sheet is this possible multi column selection using parameter could u plz help

@shubhamshah9827

4 ай бұрын

I have same issue. This is selection on a single column, I want to multi select from different columns

@shubhamshah9827

4 ай бұрын

Did you find solution?

It's looks good ..but parameters we create with dynamic names how to do multi select ? Here showing with existing dataset field segment values

Will this work if I am trying to use the parameter to filter multiple fields?

@codyphillippi8831

2 жыл бұрын

I assuming we can just result the TF to contain the other field and use that for the filter of the other field's sheet?

@whosyurdanny

Жыл бұрын

@@codyphillippi8831 That is exactly what I did. Just placed the TF filter on all sheets that I wanted to filter.

This is not useful...since we have many values ..here only 3 values you placed in small space but many values multi select can not show all together in small space in the dashboard