Conditional formatting based on attribute

[Anonymous]

I have unpivoted columns on attribute- CY, Budget and SPLY , how do I enter conditional formatting for specific PM%

example to calculate Product Margin% for CY ,if I select CY, then CY PM% -Budget PM% will be green or else if low then red,

similarly if i select SPLY, then it should be compared to CY, CY GP% -LY GP% the measure should say if greater then green or else red

the problem now is if i put a formula it applies to all PM% including budget, i only want it for CY and SPLY

[Anonymous]

I tried it, it works but the issue coming is maybe this formula i put in for product margin, it selects whatever selected as filter. I put the same for Net sales.

P&L Budget PM = CALCULATE(SUM(Append1[Product Margin]),FILTER(Append1,Append1[Attribute] = SELECTEDVALUE(Append1[Attribute])))

I want the end result to be if I select current year(in attribute current year) ,it should be CY%>bgt PM% else CY%>LY% for attribute SPLY

[Anonymous]

Screenshot here: I selected Current Year and Budget together. 

[amitchandak]

@Anonymous , create a color measure and use that conditional formatting with field values

Color = if([CY PM% ]> [Budget PM] ,"green","red")

refer: https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values