topic Can I sort a visual by its highlighted portion? in DAX Commands and Tips

Can I sort a visual by its highlighted portion?

dmelan123 — Wed, 12 Jun 2024 15:10:33 GMT

Unfortunately I can't share the .pbix file I am working with, but I can post screenshots to help elaborate.

I have a dashboard with multiple visuals. One such visual is a clustered bar chart, like this

When I filter the data by clicking on another visual, I get something that looks like this

I would like to have the visual above to be sorted by the highlighted portions. In this example, the 2nd and 3rd bars should swap.

Is there perhaphs a measure I could make based off of the highlighted portion that I can then sort on?

Thank you for your time!

Re: Can I sort a visual by its highlighted portion?

Anonymous — Thu, 13 Jun 2024 03:13:32 GMT

Hi dmelan123 ,

As far as I know, powerbi does not currently support this feature.

Sorting by highlighted sections requires sorting by Value, but Power BI is designed to sort by adding all the values in each group, not by sections.

You can submit an idea for it at Home (microsoft.com) and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Can I sort a visual by its highlighted portion?

dmelan123 — Thu, 13 Jun 2024 11:35:21 GMT

Thank you kindly for your input!