Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have a matrix displaying days and Sales. I try to use conditional formating to colorize week ends.
But it works only if the field for conditionnal format is displayed in matrix...and I don't want.
How to do please ?
I just want CA column with a bakgroundcolor for cells.
Solved! Go to Solution.
@Yogi785 , In Matrix you can do conditional formatting on only values fields, not on Column or Rows field.
For Values, you can use a measure
if( Weekday(Max(Date[Date]),2) >=6, "Grey")
and you can use the same in conditional formatting using the field value option
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/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...
Hi @Yogi785 ,
It is possible to apply the created MEASURES directly to conditional formatting, as referenced below:
Measure = IF(MAX('Table'[week_]) >= 6 ,"grey","white")
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Yogi785 ,
It is possible to apply the created MEASURES directly to conditional formatting, as referenced below:
Measure = IF(MAX('Table'[week_]) >= 6 ,"grey","white")
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello, thanks for answers, I recreated measures and it works
@Yogi785 , In Matrix you can do conditional formatting on only values fields, not on Column or Rows field.
For Values, you can use a measure
if( Weekday(Max(Date[Date]),2) >=6, "Grey")
and you can use the same in conditional formatting using the field value option
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/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...
Thanks for reply
yes I use CF on measures. The first screen on the left use a measure ("Mesure") with this formula : "if( Weekday(Max(Date[Date]),2) >=6, "Grey")"
But I don't understand why I should put this measure inside the matrix for the cells of column CA to be colored.. I don't want a column with "grey" strings.
User | Count |
---|---|
94 | |
79 | |
76 | |
65 | |
60 |
User | Count |
---|---|
106 | |
99 | |
77 | |
63 | |
61 |