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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

Sorting in a filtered visualization

I have a column chart that is sorted by the Count value. However, when it is filtered (from another visualization on the page), it keeps the sort order from the totals, and the filtered counts are out of sequence. Customer is requesting this be corrected. Does anyone know if this possible? Thanks! Rob

 

 Count by Site.pngCount by Site Filtered.png

1 ACCEPTED SOLUTION
jdbuchanan71
Super User
Super User

The problem is the visual is sorting off the total, not the highlighted amount.  If you adjust the interation to filter instead of highlight then when the user selects an element in another visual your bar chart will show only the filtered amounts and should sort correctly.

You would have to select the visual where the user is making the selection then change the interaction on the bar chart.

Format Tab > Edit Interactions.

2020-05-26_9-35-43.jpg

View solution in original post

2 REPLIES 2
jdbuchanan71
Super User
Super User

The problem is the visual is sorting off the total, not the highlighted amount.  If you adjust the interation to filter instead of highlight then when the user selects an element in another visual your bar chart will show only the filtered amounts and should sort correctly.

You would have to select the visual where the user is making the selection then change the interaction on the bar chart.

Format Tab > Edit Interactions.

2020-05-26_9-35-43.jpg

Anonymous
Not applicable

Excellent! Haven't had to do this before- this is exactly what is needed. Fortunately, I don't think there is a requirement to see the highlighted totals, so this should be fine. 

 

Edit Interactions.png

 

Filter.png

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors