Sort bar chart by a Measure

[Jose1947NK12333]

Hi

I have created a stacked bar chart. Each bar has 5 stackes, which created by a measure.

The requirement is to sort the chart by sum of two stack values.

Since the chart is built on measure i am not able t select them via "Sort by column".

Please suggest an work around.

Note: we can create the stakes by using one column in Legend field. however the value will be then a measure (SUM). I have splited the stack for sorting purpose and it works well when i am sorting by one stack. however the requirement demads adding up to stack valuse for sorting.

Regards

Jose

[JanV]

Looking for this functionality as well, did you post an idea for this Jose?

[v-yulgu-msft]

Hi @Jose1947NK12333,

Currently, it is not supported to sort chart by total value of two measures. We are able to sort chart based on any column or measure that has been added into this chart. In other words, if you want to add up two stack values for sorting, you might have to create a third measure and add this measure into chart.

Personally, I would suggest you submit this idea at this page as a feature request, if it is mentioned by many users, our product team will consider adding it to future release. Thanks for your understanding.

Regards,
Yuliana Gu

[Jose1947NK12333]

Hi

I have created a stacked bar chart. Each bar has 5 stacks. The requiremnt is to sort the chart by sum of 2 stack values.

Note: I have created 5 measures and used them as stacks. So "Sort by Column" would not work.

please suggest.

Regards

Jose