Change Date colors base on the day of the week

[dyh1006]

Hi ,

I have this visual which captures tickets assigned per day. I am trying to change the color of the date based on the day of the week. ex. if the date is a saturday then change it to yellow, if the date is a friday change it to blue etc.... I've have tried to change it using a formula but it changes all the dates with the same color. can anyone help?

[Hariharan_R]

Hi,

 For your above scenario.

1. Create Day Name calculated column = 

DayName = FORMAT([Date], "dddd")

2. Create a measure for the conditional color = 

Color = IF(MIN('Table'[DayName])="Saturday","Yellow","Red")

3. Add the above color measure under color expression 

Thanks

Hari

[dyh1006]

Thanks for reaching out. i tried your solution but it is bypassing the color yellow, it is turning all the dates to red. 

Here is the measure i created 

Here are the results now

[v-easonf-msft]

Hi, @dyh1006 

It is currently not possible to make it colorful.

Even with a formula, only one color can be preserved.

Best Regards,
Community Support Team _ Eason

[dyh1006]

Thanks for responding. I thought it was going to be possible but i we need to work with what we have. Hopefully this can be change in the future. 🙂