Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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 , 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")
)
Brilliant! Thanks a lot!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
88 | |
82 | |
65 | |
64 | |
58 |
User | Count |
---|---|
171 | |
112 | |
110 | |
72 | |
72 |