Slicer maximum value selected by default

Naveen_Kumar

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. 

---

Naveen_Kumar wrote:

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.

---

Naveen_Kumar

AFAIK, it is not possible, you can check this idea Slicer default selected values and vote it up.

Naveen_Kumar

Is your issue solved..?