Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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,
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.
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,
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.
Would I need to do like an outer join to select ALL dates?
In 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?
@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/...
Thanks for the reply @Dhacd . What do I do if no data was entered for that day? This is a sample with some test data and only one day for this month of July has data.
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |