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
NMHCClinInf3
Frequent Visitor

sort slicer by most frequent value

 

Hi,  I want to create a slicer based off of the column txt_status but I can't figure out how to sort by most frequent value like below.  How can I do this?

image.pngimage.png

 

FYI: I'm very new to coding in general but have to start somewhere!

 

Thanks

1 ACCEPTED SOLUTION
v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @NMHCClinInf3,

 

Please follow below steps.

 

1. Open Query Editor, duplicate source table which contains [txt_status] field.

1.PNG

 

2. Group the duplicated table.

2.PNG

 

3. Save and apply all changes. Create a one to one relationship between these two tables.

3.PNG

 

4. For the duplicated table, change the "Sort By" column from default one to [Count].

4.PNG

 

5. Drag [txt_status] from duplicated table into slicer.

5.PNG

 

By the way, for any new problem or requirement, you'd better post a new thread on forum.

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @NMHCClinInf3,

 

Please follow below steps.

 

1. Open Query Editor, duplicate source table which contains [txt_status] field.

1.PNG

 

2. Group the duplicated table.

2.PNG

 

3. Save and apply all changes. Create a one to one relationship between these two tables.

3.PNG

 

4. For the duplicated table, change the "Sort By" column from default one to [Count].

4.PNG

 

5. Drag [txt_status] from duplicated table into slicer.

5.PNG

 

By the way, for any new problem or requirement, you'd better post a new thread on forum.

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
NMHCClinInf3
Frequent Visitor

Not sure if I should then put this in another post but... I then want to use the filter txt_status to get the difference in minutes between the txt_time value based on distinct Enc #

 

image.png

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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