Forum Discussion

NOVICE02's avatar
NOVICE02
Helper III
6 years ago

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...
Need Help
NOVICE02's avatar
NOVICE02
Helper III
6 years ago

it didn't work... I wrote a measure to test like this:

Live_pen =
SWITCH (
TRUE (),
    ISBLANK ( [% liv_pen_var] ), "#BBE4EC",
    [% liv_pen_var] < 0 , "#DA291C" ,[% liv_pen_var] = 0 ,"#FFBF3F",[% liv_pen_var] > 0, "#00B050")
 
and followed the same steps to apply formatting based on above field value but the value is unchanged.
vivran22's avatar
vivran22
Community Champion
6 years ago

NOVICE02 

 

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

  • NOVICE02's avatar
    NOVICE02
    Helper III
    6 years ago

    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 ?