Forum Discussion
Clustered Column Chart Dynamic Y-Axis Scale or Adding Space Between Bars
This definitely would have been great help for another project I did! I was unfamiliar with unpivoting at the time and ended up using bookmarks and buttons to create something dynamic like this. I may go back during some free time and try this solution as it may be a bit more visually appealing. This could potentially work with this project... but I worry with there being too much data and more than one kind of data... I found a solution that seems functional enough.
My Solution: I have kept the format of having a separate clustered column chart for each bar, so I have four visuals. I added all four measures to each, but I made the three I'm not wanting to show in that specific visual the same color as the background (white). So for the first bar (Prior QTR), I have the other three measures included, but colored white. For the second bar, I have Prior QTR, Prior YTD, and Current YTD listed after Curr QTR and colors white so that only Curr QTR shows. And so on... This way, all of the axes are the same, the bars appear proportional, and the axes can be set to an auto range that changes according to the slicer.
My solution would be a pain if I needed to go in and select and edit these visuals in the future, but luckily I won't have to. I appreciate the help! Excited to try this in my other project when I get the chance.
Best.
Community SupportHi Anonymous ,
Refer to the teaching provided by the following video link, which can help you.
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This definitely would have been great help for another project I did! I was unfamiliar with unpivoting at the time and ended up using bookmarks and buttons to create something dynamic like this. I may go back during some free time and try this solution as it may be a bit more visually appealing. This could potentially work with this project... but I worry with there being too much data and more than one kind of data... I found a solution that seems functional enough.
My Solution: I have kept the format of having a separate clustered column chart for each bar, so I have four visuals. I added all four measures to each, but I made the three I'm not wanting to show in that specific visual the same color as the background (white). So for the first bar (Prior QTR), I have the other three measures included, but colored white. For the second bar, I have Prior QTR, Prior YTD, and Current YTD listed after Curr QTR and colors white so that only Curr QTR shows. And so on... This way, all of the axes are the same, the bars appear proportional, and the axes can be set to an auto range that changes according to the slicer.
My solution would be a pain if I needed to go in and select and edit these visuals in the future, but luckily I won't have to. I appreciate the help! Excited to try this in my other project when I get the chance.
Best.