conditional formating

[Ley022]

Hi,

I wan´t to add conditional formating but only when I have a value, so when the value is empty nothing should be applied. If I add conditional formating based on column I have the following result (blue) with It is not correct.

Thanks in advance

[nvprasad]

Hi,

Please Select don't format in the "Default Foratting' dropdown of Advanced Settings. Please refer to below snapshot.

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad

[amitchandak]

@Ley022 , Can you measure conditional formatting? create a color measure and use that with field value option

example

Color Weekday = if(FIRSTNONBLANK('Date'[Weekday],blank()) in {"Sunday", "Saturday"},"lightgreen","red")
Color Weekday = if(weekday(max('Date'[Date]),2) >=6 ,"lightgreen","red")


Color Date =
var _min =minx(allselected(Date,Date[Year])
return
 Switch( true(),
 FIRSTNONBLANK('Date'[Year],year(TODAY()))-_min =0 ,"lightgreen",
  FIRSTNONBLANK('Date'[Year],year(TODAY()))-_min =0 ,"blue",
 "red")

Refer:

Color Weekday = if(FIRSTNONBLANK('Date'[Weekday],blank()) in {"Sunday", "Saturday"},"lightgreen","red")
Color Weekday = if(weekday(max('Date'[Date]),2) >=6 ,"lightgreen","red")

Color Date =
var _min =minx(allselected(Date,Date[Year])
return
Switch( true(),
FIRSTNONBLANK('Date'[Year],year(TODAY()))-_min =0 ,"lightgreen",
FIRSTNONBLANK('Date'[Year],year(TODAY()))-_min =0 ,"blue",
"red")

[themistoklis]

@Ley022 

Under format by select rules and make sure that for blank values to put white background.

See image below:

[Ley022]

Hi,

thanks, I have applied those changes but I get the following result, an the intermittent color dissahear

[themistoklis]

@Ley022 

Can you share the file with us? Mask any confidential data

[v-janeyg-msft]

Hi， @Ley022 

Has your problem been solved? I think that the message5’s solution seems to be the fastest and most effective.

If you take the answer of someone, please mark it as the solution to help the other members who have same problems find it more quickly. If not, let me know and I'll try to help you further. Thanks.

Best Regards,
Janey Guo

[themistoklis]

And if you use colour range, change default format to 'specific colour'  and add white background.

See image