Forum Discussion
PowerBI - Comparison visualisation within a dataset using two filters of the same column
Anonymous
You can try selecting the chart and going into Y axis. Here you can change Inner padding to, like, 5, so the bars don't look so scrawny. You can also ramp up the Minimum category width a bit for th same reason, although be careful as this will push your bars off the bounds of the chart if put up too high.
You can also Go to Legend and adjust where this sits to help with the balance of the visual.
Other than these little tweaks, there's not much else you can do. A bar chart is never going to look great with loads of data points on it, it's more for clear, low-volume, comparisons I think.
Maybe try switching to Clustered column chart and see if you find this a bit easier on the eye.
Pete
Thanks for your response Pete. If i do that then it aggregates the brands opposed to allowing me to view their scores individually and compare. I.e it would look like this, which is not what i am after..
Hi Anonymous
Add the brand into the legend, like this:
Pete
That does work Pete. It has less flexibility as you can not aggregate brands together but this could work. Also my actual dataset has tens of brands and so the chart doesn't look great until just 1 or 2 are selected - any workarounds for that?
Thanks,
Anand
Anonymous
You can try selecting the chart and going into Y axis. Here you can change Inner padding to, like, 5, so the bars don't look so scrawny. You can also ramp up the Minimum category width a bit for th same reason, although be careful as this will push your bars off the bounds of the chart if put up too high.
You can also Go to Legend and adjust where this sits to help with the balance of the visual.
Other than these little tweaks, there's not much else you can do. A bar chart is never going to look great with loads of data points on it, it's more for clear, low-volume, comparisons I think.
Maybe try switching to Clustered column chart and see if you find this a bit easier on the eye.
Pete