Different color column each month

[giuliapiazza94]

Hi guys,

I have a matrix like this

I'd like to have a different color for each month

In each month I've 2 measures, so they have to have the same color in the same month.

It is possibile?

Thank you all 😁

[ValtteriN · Accepted solution]

Hi,

You can create a formatting measure like this:

ColorMeasure =

var selection = MONTH(SELECTEDVALUE(MonthColors[Date])) return

SWITCH(TRUE(),

selection=1,"Blue", //January

selection=2,"Green") //And so on, instead of color names you can also use hexacodes e.g. "FFFFFF"

Apply it here:

End result:

Then you just need to apply the logic to other columns and the logic works.

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

[Charcho]

Could this be used for column headers? I can't seem to find a way to do it.

[giuliapiazza94]

There is a small problem

How can I color all column?

[ValtteriN]

Hi,

These rows are likely caused by interaction between row level filters -> these rows don't have values in the month column so this happens. 

[giuliapiazza94]

Thank you so much 😊