select largest value automatically slicer

Hey Anonymous ,

unfortunately this is not possible. The reason for this is that a slicer has not property "default value" where you can add a measure that determines the value to determine the value that should be seleceted by default, e.g. the current day, the max value etc. 

There are some approaches that filter the values visible in the slicer. But all of these slicers come with a downside like requiring another slicer with members like ALL and Today. The selection then will control the measure that filters the available members in the base slicer. You have to be aware that these approaches do not filter they only hide or unhide what's visible in the slicer.

Another approach is to create a second table like so
Slicer | Value

MAX | 3

ALL | 1

ALL | 2

ALL | 3

Then you can create a relation between the value column and the dimension table, this relationship then has the cross filter property set to BOTH, this of course will only work if the value for MAX is not dependent from other selections as the content of this table will only be updated during data refresh.

Maybe you can upvote an existing idea on ideas.powerbi.com or create a new idea.

Regards,

Tom