how to sort by measure

[mg21082]

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?

thanks,

Moti

[v-shex-msft]

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)

Regards,

Xiaoxin Sheng