Forum Discussion
Weekend Row color
I have a table where I would like the background of a cell to be gray if it is a weekend. The whole row would be gray if it is a weekend. I go into do conditional formatting based on a calculated column I have in the calendar table. This column is called IsWeekend and will either be a Zero or a One. However when I go to set up that conditional column, the field is grayed out and cannot be selected. What is happening here? What am I doing wrong? Also, I want this gray color whether there is data or not.
Hi CMSGuy
Thanks for reaching out to us.
>>However when I go to set up that conditional column, the field is grayed out and cannot be selected. What is happening here? What am I doing wrong?
You need to createt a measure instead of conditional column, for example,
Measure = IF(WEEKDAY(MIN('Table'[date]),2) in {6,7},"grey")result
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
CMSGuy , Field value need a text measure that return color
example
if(Max('Date'[Weekend]) =1 , "Grey", "White")
How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539In Conditional Formatting Choose rules instead of a field value and apply the conditions there.
If it is not working Please share a sample dataset and I will have a look.
If this is working for you please mark it as a solution.Regards,
Atma
How can I share a dataset with you?
Would I need to do like an outer join to select ALL dates?
Hi CMSGuy
Thanks for reaching out to us.
>>However when I go to set up that conditional column, the field is grayed out and cannot be selected. What is happening here? What am I doing wrong?
You need to createt a measure instead of conditional column, for example,
Measure = IF(WEEKDAY(MIN('Table'[date]),2) in {6,7},"grey")result
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
