Forum Discussion

Giada_Togliatti's avatar
Giada_Togliatti
Post Patron
6 years ago

conditional formatting doesn't work

Hi, I've created a table with three measure and the result is a table with only one row that shows the total of each measure. I've applied conditional formatting to one measure but it doesn't work,...
Need Help
Giada_Togliatti's avatar
Giada_Togliatti
Post Patron
6 years ago

amitchandak I can't use FIRSTNONBLANK with a measure, in the formula I used a measure inside another measure

example = Switch( true(),
V_REPORT_PPM_RISORSE[measure1]>selectedvalue('Limite superiore'[Limite superiore 1]), "red",
V_REPORT_PPM_RISORSE[measure1]>selectedvalue('Limite inferiore'[Limite inferiore 1]) &&
V_REPORT_PPM_RISORSE[measure1]<selectedvalue('Limite superiore'[Limite superiore 1]), "light green","yellow")

 

and, do you know if it's possible to apply conditional formatting for total in a table?

v-deddai1-msft's avatar
v-deddai1-msft
Community Support
6 years ago

Hi,

 

You should change the 'Apply to' options to Values only:

 

 

Best Regards,

Dedmon Dai