Forum Discussion

JoshP11's avatar
JoshP11
Icon for Helper II rankHelper II
3 years ago

Edit Clustered Column Chart - X Axis and Spacing

Hello!   I'm still learning PBI and wondered if what I'm trying to do is possible.   I have this clustered column chart here:   However I want it to look like this, but can't seem to see ...
Need Help
Kishore_KVN's avatar
Kishore_KVN
Icon for Solution Sage rankSolution Sage
3 years ago

Hello JoshP11 ,

 

I can observe that all are measures so instead of just creating measures created a calculated table using ADDCOLUMNS DAX and append all these calculations into rows in a new table. Then create visual using stacked/clusted column chart that will help you in solving your requirement quickly. 

 

Another way is you have to group those measures in the visual and also you have to create one reference column as you can not take measure in X Axis. 

 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

  • JoshP11's avatar
    JoshP11
    Icon for Helper II rankHelper II
    3 years ago

    Hello Kishore_KVN 

     

    Thanks so much for the reply!

     

    I'm not sure how to do what you're suggesting. is there any easy way to show via screenshots or a tutroial I could follow? I can see where I would create the table, I'm just not sure on the rest..

     

    Thank you again.