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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
weilip1803
Frequent Visitor

Sort by Highlighted fields

Hi can i sort the columns by the amount of highlight?

4 REPLIES 4
weilip1803
Frequent Visitor

Thanks for the replies. But what i actually mean is after filter, the columns are highlighted. Can i sort by the highlighted portion?

 

Habib
Continued Contributor
Continued Contributor

If you want to sort the only higlighted values, that would not be possible. Best way would be to edit the interaction between graphs and then slect Filter option instead of Highlight option. This way highlight will not work but you will get sorted values all time.

 

Capture.PNG

v-sihou-msft
Microsoft Employee
Microsoft Employee

@weilip1803

In Power BI Desktop, you can only sort data by column within same visual.

Capture387.PNG

I don't know what do you mean "highlight fields", but you can always select a column for sorting and it will sort based on based values in this column.

 

Regards,

SamLester
Microsoft Employee
Microsoft Employee

Yes, it is a bit contrived, but those whole number values are not used/required to answer the homework questions at the end of the lab.

 

Thanks,
Sam Lester (MSFT)

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.