Forum Discussion

PBIraja's avatar
PBIraja
Frequent Visitor
4 years ago
Solved

conditional formatting

Hi, how to apply the  background color based on below conditions.   +-5% format the the cell background to YELLOW  greater than 5% format the cell background to GREEN  less than -5% format the ...
Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    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.

PBIraja's avatar
PBIraja
Frequent Visitor
4 years ago

Hi all

 

Any Logic for the above issue?