Forum Discussion

Naveen_Kumar's avatar
Naveen_Kumar
Microsoft Employee
8 years ago

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.
Interesting Links
Need Help
Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
8 years ago
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's avatar
pxg08680
Resolver III
8 years ago

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