Sorting Clustered column chart for each month in x axis

[bhargavanand]

Hi,

I have a clustered column chart. On X axis, I have month column, on Y axis I have (number of workers) measure. I used Countries column as legend. For each month, I have data of number of workers for each country. I want to sort the Y axis (number of workers) for each month. So for February, number of workers should be sorted and look like 7, 6, 5 and respectively for January and March. How can I implement this?

Thank you.

[Syk · Accepted solution]

I believe this is what you're looking for?

[bhargavanand]

Hi @Syk ,

When I change the order of bar chart columns using the layout you mentioned and trying to bookmark the descending and ascending order of the bar chart visual, it is only showing the latest change I made to the visual for all bookmarks. Do this 'Sort by value' in layout will not work for bookmarks?

[Syk]

Bookmarks keep quite a bit of information and its likely that its being reverted in your bookmark. I'd suggest navigating to your bookmark, update the sort by then right click your bookmark and update it.

[bhargavanand]

Thank you so much 👍. Struggling from 3 days for this.