Forum Discussion

LUCASM's avatar
LUCASM
Icon for Helper IV rankHelper IV
1 year ago

Conditional formatting

I am trying to set a formatting rule where, IF my product value is < the selected product value then Background colour = PINK, if My Product value > the selected product value then Background colour ...
Need Help
LUCASM's avatar
LUCASM
Icon for Helper IV rankHelper IV
1 year ago

danextian, Jai-Rathinavel 
Thank you for your solutions, I think I have resolved this now using this mod in my code.

VAR My_Product = 
CALCULATE ( 
     MAX ( 'Table'[Value] ), 
     ALL ('Table ),
     'Table'[Brand] = "My_Brand" 
)

Which I believe, removes all filters and then reapplies the brand filter.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi,LUCASM 
We are delighted that you have found a solution and are willing to share it.

 

 If you’re inclined, you might consider accepting this solution, as it could also assist other community members facing the same problem, enabling them to find a resolution more swiftly.

Thank you for your valuable contribution to the community, and we wish you all the best in your work.

 

Best Regards,

Leroy Lu