Edit Clustered Column Chart - X Axis and Spacing

JoshP11 · ‎09-11-2023

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 anywhere to do this? Ideally I would have some spacing between each of the different tests as well, so Test A's stay connected together, then some space, then Test B's connected together...

I thought this might have been fairly simple to do but I've played around with all the formatting settings and nothing.

Any help or advice would be massively appreciated 🙂

JoshP11 · ‎09-12-2023

@Kishore_KVN - thank you. I watched and followed the video however it didn't seem to work for me!

I've since changed my data so that I no longer need a measure to get the calculation, however the visual still doesn't display the text underneath the column.

Since I'm no longer using measures, is it possible to do now? If so again i'm struggling to understand a way.

Thanks,

Josh

Kishore_KVN · ‎09-11-2023

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 · ‎09-11-2023

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.