topic Re: Different color column each month in DAX Commands and Tips

Different color column each month

giuliapiazza94 — Thu, 13 Jan 2022 11:41:13 GMT

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 😁

Re: Different color column each month

ValtteriN — Thu, 13 Jan 2022 12:05:38 GMT

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!

Re: Different color column each month

giuliapiazza94 — Thu, 13 Jan 2022 12:35:22 GMT

Thank you so much 😊

Re: Different color column each month

giuliapiazza94 — Thu, 13 Jan 2022 12:53:20 GMT

There is a small problem

How can I color all column?

Re: Different color column each month

ValtteriN — Thu, 13 Jan 2022 14:25:16 GMT

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.

Re: Different color column each month

Charcho — Fri, 04 Apr 2025 09:10:34 GMT

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