My stack bar chart unable to sort by sales ?

[admin11]

Hi All

i have a stack bar chart , i am unable to sort by sales amount. may i know why ?

my PBI file :-

https://www.dropbox.com/s/fdrvh69jyrp4jj2/PBT_V2021_396%20TI_SI_GL%20SAMPLE_.pbix?dl=0

Paul

[Pragati11 · Accepted solution]

Hi @admin11 ,

Your chart is alreday sorted by SALES metric. You can test it out as follows:

Remove CUSTOMER NAME from legend part, you get the following chart which is sorted by SALES in descending order:

Now when you move the CUSTOMER NAME as the legend, the sorting stays same:

Compare the highlighted X-axis in both the above charts which are in same order with Legend and without Legend. This suggestes they are sorted by sales metric.

The chart is confusing because you are using a Stacked Column Chart which is showing a distribution of every CUSTOMER within a GROUP CLASS.

Thanks,

Pragati

[admin11]

@Pragati11 Lady are very detail. Thank

[Pragati11]

I like detailed and clear responses. 🙂

[amitchandak]

@admin11 , On the three dots you have the option to sort my measure(sales). Try to use that