Forum Discussion
How to avoid a parameter select all columns in slicer
Hi everyone, I'm developing a self service analysis dashboard. Long story short, the user will select the column via a slicer and fill a table. Now the problem is this: The table...
Hi AresB
ray_aramburo Good share!
For your question, here is the method I provided. You can try the following:
"Table"
Create measures. Determine whether the slicer is selected. If selected, display the data, otherwise the display will be empty.
_id = IF(ISFILTERED('Table'[LOCAL]), VALUES('Table'[LOCAL]), BLANK())
_name = IF(ISFILTERED('Table'[NAME]), VALUES('Table'[NAME]), BLANK())
_values = IF(ISFILTERED('Table'[LOCAL]) && ISFILTERED('Table'[NAME]), VALUES('Table'[VALUES]), BLANK())
Here is the result.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hi Anonymous ,
your method doesn't work in my case, i need to fill the slicer with the column headers, not the values of the columns.