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,
how to apply the background color based on below conditions.
thanks,
raja.
Solved! Go to Solution.
Hi, @PBIraja
You can try the following methods.
Measure:
Measure =
IF (
SELECTEDVALUE ( 'Table'[Change] ) <= -0.05,
"Red",
IF ( SELECTEDVALUE ( 'Table'[Change] ) >= 0.05, "Green", "Yellow" )
)
Apply Measure to the background color of the percentage as shown in the figure.
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @PBIraja
You can try the following methods.
Measure:
Measure =
IF (
SELECTEDVALUE ( 'Table'[Change] ) <= -0.05,
"Red",
IF ( SELECTEDVALUE ( 'Table'[Change] ) >= 0.05, "Green", "Yellow" )
)
Apply Measure to the background color of the percentage as shown in the figure.
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi all
Any Logic for the above issue?
@PBIraja , Assume you measure based on that you need that +/-
a new measure =
Switch(True() ,
[Measure] *.95 , "Red",
[Measure] * 1.05 , "Green",
"Yellow"
)
use this conditional formatting using the field value option
How to do conditional formatting by measure and apply it on pie? : https://youtu.be/RqBb5eBf_I4
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
89 | |
86 | |
75 | |
69 | |
68 |
User | Count |
---|---|
220 | |
128 | |
117 | |
82 | |
77 |