How to set default value for slicer but enabling multiple slicer selection

[arielcedola]

Hi,

I'm using RANKX to set a default value to a filter in several visuals, as follows:

YearRank = RANKX(ALLSELECTED(Sales[Year]), CALCULATE(MIN(Sales[Year])),,DESC,Dense)

I set the current year (top ranked year in the ranking) as the default year in each visual by applying the Top N filter type as follows:

In this way I see only the records for the current year when I come to the report, which is the effect I was looking for. Therefore with the slicer I can easily see the records for the previous years, but if I want to see records for 2 or 3 years together, through a multiple selection in the slicer, obviously using this method it's not possible.

How could I set the by default visualization of the records for the current year, but having still the chance to select multiple years to visualize?

Here the link to the pbix file.

https://drive.google.com/file/d/1Z3JizbdKVR4XV98K0zdFopTCAWULumdH/view?usp=sharing

Thanks.

[v-jayw-msft · Accepted solution]

Hi @arielcedola ,

You can use ISFILTERED() function to check if the column is filtered. Then set default value if it returns false.

https://docs.microsoft.com/en-us/dax/isfiltered-function-dax

Best Regards,

Jay