Forum Discussion
Helper IIEdit 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 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 🙂
4 Replies
- Kishore_KVN
Solution Sage
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!!
JoshP11Hello 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.
- Kishore_KVN
Hello JoshP11
Please see below video this may help you.
- JoshP11
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
