Forum Discussion
Conditional formatting based on another table
I cannot figure this thing out and i feel that it is too simple. I have data that I direct query and have put into a table to look at month to date values by different metrics. I have created a targ...
Once I write the measure.. I choose the able and select var. penetration... which is the measure defined in:
Live_pen =
SWITCH (
TRUE (),
ISBLANK ( [% out_liv_pen_var] ), "#BBE4EC",
[% out_liv_pen_var] < 0 , "#DA291C" ,[% out_liv_pen_var] = 0 ,"#FFBF3F",[% out_liv_pen_var] > 0, "#00B050")
From conditional formatting i select format by field value and choose the measure that i created and click ok...
and nothing... am i missing a step ?
You have followed all the steps, but still not getting the desired result. Is it possible to share the pbix file with the sample data?
Cheers!
Vivek
https://www.vivran.in/
Connect on LinkedIn