Why a field which a conditional formatting is based on need to be displayed?

[Yogi785]

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.

with

[amitchandak · Accepted 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...

[v-kongfanf-msft · Accepted solution]

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.

[Yogi785]

Hello, thanks for answers, I recreated measures and it works 

[amitchandak · Accepted 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...

[Yogi785]

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.