How to sort bar chart by only one of two selected values

[LunaLabs]

Hi there,

could u please help me to sort the graph in the picture by only the value related to "08-AGOSTO"?

Now the software is sorting by the sum of the two months. ("Agosto" and "Luglio" are two italian months)

Many thanks!

[v-rongtiep-msft · Accepted solution]

Hi @LunaLabs ,

It seems you are using Legend in the chart and the categories are from same column. In that case, you can not sort the chart by a single category from the column. You might consider to create a measure for each category and add these measures to Vlaue field instead of using Legend column.
For example:

X = CALCULATE(MAX('Table (4)'[sales]),FILTER('Table (4)','Table (4)'[Category]="x"))

Y = CALCULATE(MAX('Table (4)'[sales]),FILTER('Table (4)','Table (4)'[Category]="y"))

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

Best Regards

Community Support Team _ Polly

[amitchandak]

@LunaLabs , You can not sort my a legend filtered value. You can create a measure that gives august (Last Month) data and use that on tooltip and try to sort on that