Customise Clustered Column Chart Bars

[Anonymous]

Hi,

Does anyone know if there is a way to customise the bar color?

For example, current month = Mar 2021, months before Mar2021 is light blue, Mar 2021 and onwards is dark blue. Likewise for the Grey bars.

Any tips would be greatly appreciated!

What I want to achieve:

Currently what I have in Power BI

Regards,

Bee Kee

[amitchandak]

@Anonymous , there three options, and none of them able to create the gap you want

Minimum Category Width

Inner padding

Maximum Size

You can check if they can help

[Anonymous]

Hi @amitchandak ,

What I am trying to achieve is customising the bar colors based on the current month

Thanks!

Regards,

BK

[amitchandak · Accepted solution]

@Anonymous , Conditional formatting does not work with more than 2 measures