Showing results for 
Search instead for 
Did you mean: 
mg21082 Occasional Visitor
Occasional Visitor

how to sort by measure

hi, i am new to PBID.


i have created a simple to horizontal bar charts. the charts present measures values from the same sql table (see attached pictures).

right visual shows count of faults by fault name, and the left visual shows count of components.


when i select the highest value in the right visual, the left visual is sorting, but i want to see a sort decending of components count value, and not as it shown.


how can i achieve this with PBID?




Community Support Team
Community Support Team

Re: how to sort by measure

Hi @mg21082,


AFAIK, current you can set up sort order based on axis and value fields, if your measure is store in value fields, it can set as 'sort order'.


You can click on '...' to open option panel to see more detail:


BTW, power bi not support auto re-sort on highlight effect.(highlight not really affect visual data)



Xiaoxin Sheng

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

For learning resources/Release notes, please visit: | |