Forum Discussion

LUCASM's avatar
LUCASM
Helper 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
Helper 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