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...
I am not sure how you are applying it. I have used the same formula and it is working for me:
Can you share more details on this?
Cheers!
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂
https://www.vivran.in/
Connect on LinkedIn
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 ?