How to group/secondary axis level data in power bi?

[Anonymous]

Hi everyone,

I tried to achieve this kind of data in power bi but with no luck. It's quite easy to be done in power pivot. The data is sorted by grand total from the largest to smallest and is grouped by code.

 Alternatively, I tried to add three charts while the first one's code is filtered by the largest sum of price.  I finally managed to achieve this by using calculated columns, one column is the sum price regardless of color or year, another one is using the earlier function to achieve the rank. Then you can filter the rank column to show the Code-C(largest sum) chart. 

 But this leads to another problem. For code A and Code B, they have the same price total. I can not seperate these two charts by simply choosing the visual filter in power bi.

 So Is there any better way to do this? Anyone have any idea?

Thanks in advance!

[Greg_Deckler · Accepted solution]

Looks like a Matrix visualization should get you what you want.

[Sean · Accepted solution]

@Anonymous Create the Stacked Column Chart with the fields as in the picture and then click the Expand All... Button

This should give you kind of what you are looking for

You may have to adjust the size (width) of the chart!

Afterwards Please Vote here (so we can do this like in Excel)

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11524623-nested-x-axis-labels

[Anonymous]

@Sean

Yes, this is exactly what I'm looking for, thx very much!

[Greg_Deckler · Accepted solution]

Looks like a Matrix visualization should get you what you want.

[Anonymous]

Hi smoupre,

Thanks for your reply.

I tried the matrix visualizaiton , and it works like a charm for pivot table.

But do you know how to turn this matrix into grouped charts like what it shows in the pivot?

 Thanks!