Clustered Chart - 2 X-Axis

[Anonymous]

Hello,

I'm trying to replicate a graph similar to the below Power BI from Excel however i'm finding it hard find a visualisation where you can have 2 x-axis. 

When I try and create the graph it just splits FY19/FY20 and clusters them all together instead of seperating them by details such as enquiries or calls

Thanks,

Mark

[v-yiruan-msft · Accepted solution]

Hi @Anonymous ,

Please check if the custom visual Clustered Column Chart By Akvelon can meet your requirement.

Best Regards

Rena

[DataZoe]

Hi @Anonymous,

You can do this by turning off the "concatenate labels" on the x-axis and also you have to go to the chart and sort it by the x-axis values (via the ... menu on the chart itself) after you have expanded it down (the forked arrow on top menu you when hover over the chart) -- which should show it as concatenated. Even if it's already sorted by them, just click it again and it will reformat.

Hope this helps!

[parry2k]

@Anonymous not sure how you are doing it, you should add category and then year on x-axis and drill down to year level using in-line hierarchy button (fork looking button on top right corner)

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡