hi

[abc_777]

Hello,

I have a calendar table. here i want to change the colour of day of week (friday and saturday) to be red and others (sunday. monday, tuesday, wednessday, thrusday) to be black.

as well as

I want to change the calendar day of month according to friday and saturday to be red and rest would be black

Please help me the process if possible

thanks

[lucadelicio · Accepted solution]

Hi abc i'll be happy to help you. Can you post the pbix?

You have to create a measure to use in the conditional formatting settings.
Using the dax function Switch you have to scroll the Calendar[WeekDay] and return the color result that you want.
Try something like this:
ConditionalFormattingMeasure = SWITCH ( [WekDay], "Friday", "#FF2701", "Saturday", "#FF2701", "#000000")
https://learn.microsoft.com/it-it/dax/switch-function-dax
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

 Luca D'Elicio

[abc_777]

@lucadelicio ,

thanks for your reply so quick,

I am trying to create a sample file if possible, as it takes time reasoning of the calendar table that i gave in my previous post takes long time to create and has company data in it.

But i will try my best to create.

In mean time i have created a calculative column  using 

test week color = SWITCH ( [Day Of Week], "Friday", "#FF2701", "Saturday", "#FF2701", "#000000")

then i go to font colour from Cell element menu

please guid me what next

thx

[lucadelicio]

You have to create MEASURE not calculated column.
Then you can use in the conditional formatting.
Try this.

[lucadelicio]

set a googl meeting on lucadelicio@gmail.com i'll be happy to help you.

[abc_777]

thx for the reply, whats your time difference?

[lucadelicio]

i'm GMT+2 now is 13:09.
I go out for some hours if you are available put it at my 16:00 (in 3 hours).
Thank you very much

[abc_777]

i am GMT+6 means and my current time is 5.30 pm

so with you time difference is 4 hr

3 hr later mean my time would be8-830 pm today

i be online then

thx

[abc_777]

i have sent a meeting request via google meet about 2 hrs time fro now

thx

[abc_777]

i m free from on ward

[lucadelicio]

i'm waiting in the meeting