Forum Discussion
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,...
it depends on your measure statements
amitchandak the measure used for conditional formatting that work with more rows but not with one row is this:
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")
where limite superiore and limite inferiore are two parameter