How to sort top 10 products in a column chart by using a different measure

[Anonymous]

Hello,

I would like to create a dashboard with 3 column charts. The 1st one should show top 10 products based on Sales measure and below I want to add 2 similar column charts with the same order of these top 10 products, showing their Growth and Market share values respectively. So, the sort axis should be defined by the 1st column chart and should be respected in the following 2 column charts (even I will not use Sales as measure in these 2 charts).  All 3 measures are part of a calculation table I have created. I cannot find a similar process as we do when we "sort by another column" in a table.

Any idea how can I execute this task?

Many thanks!

[Alf94]

Hi @Anonymous ,

The trick is to add your Sales measure to the tooltips of the two other column charts. When a measure is added to a chart, you can then sort this chart by this measure. See below:

I have my three columns charts with same sort as in the first one:

The second and third charts are sorted by sales amount.

Hope this helps.

If I answered your question, please mark my post as a solution.

Best,

[Anonymous]

Hi @Alf94 ,

many thanks for your response. Indeed, it's a good idea, although I am not sure if we can have dynamic solution in this way. That means, if the user wants to switch the order of Products, based on a different rule (from Sales to Growth or Market Share), I am not sure if it will be possible.

Please let me know if you have any idea on this.

Thanks again. 

[Alf94]

@Anonymous,

I fully agree that this is not a dynamic solution. If the user changes the sorting of the first column chart, the other two column charts will unfortunately retain the same sorting as at the start.

However, I am not sure there is a better solution to your problem, sorry.