Forum Discussion
Slicer maximum value selected by default
By default maximum value should be selected in a slicer example: My slicer values if a new value(High) is added then the slicer should become like automatically.
You're trying to make a default selection for max slicer value when ever you open your report..
I fthis is what you are trying to do it,
Step 1:
Create a calculated column , find the max value for the column that is used by the slicer.
This gives a new MAX column.
Step 2:
Create one more calculated column. Use IF statement, if the slicer column value is equal to MAX return that value, else return the rest of the values.
Step 3: Use the column that is obtained in Step2 as your new slicer column and keep the selection to the max value and save.
That's it.