Filter values of slicers

[maneschr2022]

Hi all,

I´m trying to work for the proper DAX to filter the values of my slicer as I don´t want to show all the slicer values options for a visual that has much fewer values than the slicer is showing.

I`ve been reading that is possible to use a Dax for that and add it as a filter on the slicer visual.

I tried to use the below DAX on the "Filter on this visual" for the slicer but the values of the slicer are not reducing to show just Red, Yellow and Green.

DAX:

Filter colours= CALCULATE(COUNTROWS(TABLE),FILTER(TABLE,TABLE[COLUMN] IN { "Red", "Yellow","Green"}))

Thanks in advance for help!

[v-easonf-msft · Accepted solution]

Hi, @maneschr2022 

If you are using a calculated column, please try the following formula:

Filter colours =
IF ( 'TABLE'[COLUMN] IN { "Red", "Yellow", "Green" }, 1, 0 )

Then drag this field  to visual filter pane as below:

Best Regards,
Community Support Team _ Eason

[amitchandak]

@maneschr2022 , Use this measure in the visual level filter of slicer and check for non blank value