Forum Discussion
Conditional formatting based on attribute
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% -Budge...
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
Screenshot here: I selected Current Year and Budget together.