how to set the slicer always select the maximum value of a field

[oakfootballclub]

Hi experts, how to create a slicer based on a column that it's value may changes by different refresh
but always select the maximum as default, and the slicer should be able to select multiple values.

do you know how to make it?

[v-yohua-msft · Accepted solution]

Hi, @oakfootballclub 

I create a sample table:

Then create a caculated column and try the following dax:

IsMax = IF([Sales] = CALCULATE(MAX([Sales]), ALL('Table')), "Max", "Not Max")

Create a slicer based on an IsMax column. By default, the slicer is set to display a Max value. Use the selection pane to hide the slicer.

Assign a bookmark to a button or image, so when you click on it, the slicer will select the "maximum" value.

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[elitesmitpatel]

please share the pbix file 

[bhanu_gautam]

@oakfootballclub , To achieve this we can use Custom column and Measure

First create a calculated column which identifies maximum value in the column you want to use for the slicer

MaxValueFlag =
IF(
'YourTableName'[YourColumnName] =
CALCULATE(MAX('YourTableName'[YourColumnName]), ALL('YourTableName')),
1,
0
)

Then create a measure to identify the maximum value in that column

MaxValue = CALCULATE(MAX('YourTableName'[YourColumnName]), ALL('YourTableName'))

Create a Slicer:

Add a slicer to your report.
Drag the column you want to use for the slicer to the slicer visual.
Set the Default Selection to the Maximum Value:

To set the default selection to the maximum value, you need to use a bookmark.
First, select the slicer and choose the maximum value manually.
Go to the View tab and enable Bookmarks.
Click on Add to create a new bookmark and name it (e.g., "DefaultMaxValue").
Make sure the slicer is set to allow multiple selections by enabling the "Select Multiple" option in the slicer settings.

[oakfootballclub]

you mean that there are two pages according to bookmark, one page is max value and the other is other multiple selection page? how to make it without bookmark?

[bhanu_gautam]

Actually there is one bookmark for Default slicer setting and other is slicer setting to allow mutiple selections

Currently there is no other way to set default slicer value