Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
oakfootballclub
Helper IV
Helper IV

how to create a slicer always select the maximum value of a certain column after data refresh?

Hi experts, I want to create a slicer always select max value of a certain column, is there any solution? 

1 ACCEPTED SOLUTION
RossEdwards
Solution Sage
Solution Sage

Yes but not in the way you are expect.  When you put a slicer onto a page, its going to remember the literal selection.  So what we want to do is create a new column, that replicates the old slicer column as text, but replaces the "max" with an unchanging phrase that you can select as default. 

 

For example, lets pretend your slicer column is a date column and the maxium value is going to be todays date.  Your new column will be of type "Text" and you will need to write some code that says something along  the lines of

If [Date] = <Todays Date> then "Today" else Text.From([Date], "dd-MMM-yyyy")

 

Now when you put this new column in your slicer, you will select "Today" which it will remember.  Today, as a value, will be updated every time you refresh your model.

View solution in original post

1 REPLY 1
RossEdwards
Solution Sage
Solution Sage

Yes but not in the way you are expect.  When you put a slicer onto a page, its going to remember the literal selection.  So what we want to do is create a new column, that replicates the old slicer column as text, but replaces the "max" with an unchanging phrase that you can select as default. 

 

For example, lets pretend your slicer column is a date column and the maxium value is going to be todays date.  Your new column will be of type "Text" and you will need to write some code that says something along  the lines of

If [Date] = <Todays Date> then "Today" else Text.From([Date], "dd-MMM-yyyy")

 

Now when you put this new column in your slicer, you will select "Today" which it will remember.  Today, as a value, will be updated every time you refresh your model.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors