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,...
amitchandak , Tahreem24 , az38 I've applied the same conditional formatting I need (a conditional formatting based on another measure) and it works, why if I tried to use the same in a table like the attached on it doesn't work?
In attached an example: if I add a dimension like product name and I have more rows it works
If I remove product name is again without color
This is my question, I hope I've explained well my problem in real case
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