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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

how to set slicer select top 1 value

Hi, here is one situation that the slicer is setted single select and the value should selected as top1 value of the column, Is there any setting to accomplish that? Thank you

1 ACCEPTED SOLUTION
v-xiaotang
Community Support
Community Support

Hi @Anonymous 

please try this solution  How to set default value in Power BI Slicer - EnjoySharePoint

vxiaotang_0-1669012287824.png

vxiaotang_1-1669012310201.png

 

Best Regards,

Community Support Team _Tang

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

View solution in original post

3 REPLIES 3
v-xiaotang
Community Support
Community Support

Hi @Anonymous 

please try this solution  How to set default value in Power BI Slicer - EnjoySharePoint

vxiaotang_0-1669012287824.png

vxiaotang_1-1669012310201.png

 

Best Regards,

Community Support Team _Tang

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

amitchandak
Super User
Super User

@Anonymous , In the visual level filter you have an option for TOP N for all categorical columns, use that

TOPN: https://youtu.be/QIVEFp-QiOk

Anonymous
Not applicable

The solution in the video did not fit my question actually, what I need is to find a way that make the singel-select slicer always select the max value in the slicer when open the report

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors