Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Customise Clustered Column Chart Bars

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

 

Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    5 years ago

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

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi amitchandak ,

       

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

       

      Thanks!

       

      Regards,

      BK

      • amitchandak's avatar
        amitchandak
        Super User
        5 years ago

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