Slicer maximum value selected by default

[Naveen_Kumar]

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.

[pxg08680]

@Naveen_Kumar

Is your issue solved..?

[Anonymous]

@pxg08680  thank you, this was helpful!

[Naveen_Kumar]

As there is a change in our requiremnet, we are least bothered about the current issue.
Thanks for your concern.

[Eric_Zhang]

---

@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.

[pxg08680]

@Eric_Zhang

I have done it. Don't know whether it is a right way but it's working fine for me.

[Eric_Zhang]

---

@pxg08680 wrote:

@Eric_Zhang

I have done it. Don't know whether it is a right way but it's working fine for me.

---

@pxg08680

Could you share me the pbix file? Does it even work when data refreshes?

[pxg08680]

@Eric_Zhang

Yes it works absolutely fine with data refresh.

I have few reports that run on DATE filter default selection to maxdate and this works same with other columns also.

I can give you my report as an example.

What my req is, by default the most recent date should be selected when I open the report.

STEP1:

Extract YEAR,MONTH,DAY from you dates and make the extracted column DAY as TEXT type.

STEP2:

Calculate max date from you available dates.

STEP3:

Create a new Column 

The above column gives you DAY column with maxday as CURRENT(AS for my req I had written as current).

STEP4:

Drop YEAR,Month,CurrentDay into HIERARCYSLICER(*as for my req)

H

Here MAXDATE from my DATE is 11/7/2017. As for my req 7 is represented as Current.

I tried doing this with other columns also and it was working good.

Regards,

PXG08680

[pxg08680]

@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.