Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Clustered Chart - 2 X-Axis

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

Need Help

3 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    6 years ago

    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.⚡

  • DataZoe's avatar
    DataZoe
    Icon for Microsoft Employee rankMicrosoft Employee
    6 years ago

    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!