Clustered Column Chart

[Caldowd98]

Hello community,

I have 3 clustered column charts side by side and im looking to make them fill the page a little more as there is a lot of white space around the bars. I also want too add some conditonal formatting to the columns.

It is 15 different measures in each, and the final one is an index where i would like to show a Green if positive and a Red if negative. Is this possible ?

Thanks

[Mayank_Yavda · Accepted solution]

Hi @Caldowd98 ,

Here is Clustered Bar chart Side-by-side which will help you to get clustered bar chart with less spacing which you can change through upper and lower bound. Apart from it, you can have third bar chart with conditional formatted.

Side-by-Side Clustered Bar Chart, PBIVizEdit.comClustered Bar Chart Side-by-Side , PBIVizEdit.com

Download link for the custom visual file in this page,

https://pbivizedit.com/gallery/side-by-side-clustered-bar-chart 

This was made with our Custom Visual creator tool PBIVizEdit.com. With this tool,

• anyone, irrespective of technical skills, can create their own visuals
• 15 minutes to create a visual from scratch
• opens up many additional attributes to edit (for e.g. labels, tooltips, legends position, etc)

Give this a shot and let us know if you face any problem/errors.
You can use the editor to modify your visual further (some modifications cannot be done in Power BI window and have to be in editor).

Thanks,
Team PBIVizEdit

[Anonymous]

Hi @Caldowd98 ,

According to your provided screenshots, it seems that what you are creating is clustered bar chart not clustered column chart. If you want to reduce the spacing between the bars in clustered bar chart, you can do so by reducing the value of the Inner padding option. You can set it by referring to the following screenshots:
1. New Format pane(Format your visual pane --> Bars --> Spacing --> Inner padding)

2. Old Format pane(Format pane --> Y axis --> Inner padding)

If the above is not the result you want, please provide a simplified pbix file without any sensitive info. 

In addition, regarding the conditional formatting base on index, where is this ultimately applied? Are you trying to format the color of the bars conditionally? You can refer to the following links to use conditional formatting.

Use conditional formatting in tables

Conditional Formatting By Data Bar In Power BI

Best Regards

[Caldowd98]

Hi

Thank you for your response

On the bar charts, i want to make the bars wider to fill the whole chart and take up some of the white space.

I have changed the minimum category width and also the maximum size % but there is still a lot of white space.

Im also looking to add some conditonal formatting for the data colours of the measures, but i cant see evidence that this is possible.

[lbendlin]

I don't seem to have problems doing that

Are you by any chance using a stacked bar chart rather than a clustered bar chart?

[lbendlin]

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where you are stuck?