Two different sets of conditional formatting in gauge visual based on slicer selection

[Anonymous]

Hi,

I am using a gauge visual to display the on-time carrier performance. This performance is divided into gross and net performance, where gross includes uncontrollable cirucmstances why a carrier has arrived late. I added gross and net in a slicer with a dynamic target. Gross target = 95% and net target = 97%.

Now I am running into a problem with the conditionnal formatting.

Gross = If value is lower than 95% turn gauge red, if between 95 and 100% turn green.

Net = If value lower than 97% turn gauge red, if between 95 and 100% turn green.

With standard conditionnal formatting in rules it seems I can only add a rule based on one value instead of setting separate formatting rules when slicer hits Net or Gross. See example below.

Hope someone could help me out with this one. Maybe @amitchandak ?

Kind Regards,

Sofiën

[amitchandak · Accepted solution]

@Anonymous , I am assuming slicer switches gross and net

Create a color measure  , and use that is conditional formatting using field value option

Switch(selectedvalue(slicer[Measure]),

"Gross", Switch ( True() , [Gross PD] < .95 "Red", "Green")

"Net", Switch ( True() , [Net PD] < .97 "Red", "Green")

)

[Anonymous]

Brilliant! Thanks a lot!