Color coding for a visual

[aditya_141228]

This is a visual that I'm using with Year column in legend

Since there is only one year (2024) present in the Year column so I'm not able to change the color of these columns which are blue as default. Suggest a way to change the color of these columns. A single color will work too but I don't want this blue colored columns and as it oes not match with the look and feel of the dashboards.

Any help or suggestions will be appreciated. Thank You

[rajendraongole1]

Hi @aditya_141228 -you can try the approach provided by @Ritaf1983 , adding to that with conditional formatting column level color (fx) also you can able to change the color visual format.

as you mentioned one year, you can define a measure for year as below represent the color in visual pane as below:

create a new measure 

ColorMeasure = IF(MAX('financials'[Year]) = 2024, "#FF5733", "#33FF57")

you can use conditional formatting and define the color for your x axis

final result based on legend color , you can achieve this.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[Ritaf1983]

Hi @rajendraongole1 

Please note that once you use a legend , you cannot apply conditional formatting...

[rajendraongole1]

Hello @Ritaf1983 -Agreed and i am aware of it.

In my snapshot if you can see i have added color measure for year, to show the difference with conditional formatting based on year instead of placing the year field on legend.

Thank you.

[aditya_141228]

Actually currently I have data of only 2024 but in future we'll be having more data of different years and no filters are applied but default theme worked. This is the solution.

[Ritaf1983 · Accepted solution]

Hi @aditya_141228 

What is the purpose of including the year in the legend if the analysis is only for one year?

Assuming that there is more than one year in the database and 2024 is currently displayed as a result of filtering, then you can remove the filter, change the color, and filter back again (the color will be preserved).

The other option is to modify the theme's default colors

the pbix with the examples is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.