Forum Discussion
Solved
hi
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...
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
i m free from on ward
i'm waiting in the meeting