Customised sorting in Mekko Chart

[#1]

I’ve created one Mekko chart.  It has two dimension.

I need Customised sorting

1. For 1st Dimension from Left to Right as E, W, N, S & G
2. For 2nd Dimension from bottom to top – F, O, T, D

How to get the above customized sorting in the Mekko chart view

[Digvijay_Singh]

Please share some sample data if possible.

[vcanale]

Hi,

If none of the standard sorting available is suitable for your case, you can think about a Sorting Expression and select Expression in the Sort Tab in the Chart Properties

[#4]

Hi,

Tried doing this, but it is working for 1 dimension and not for another

[ashwanin]

Can you share sample data?

[#6]

Hi,

With Expression I was able to do so.  Thanks

[#7]

Another query,

The second Dimension Labels are appearing as Legends, How can I show them as Labels against Y-axis, i.e. Vendor Name, instead of Legend want to show them against respective Mekko bar

[vcanale · Accepted solution]

working fine for both dimensions now ?

[#9]

Yes, very much

[vcanale]

Not sure it's possible to do it.. normally you see Numerical Values on Y-axis