Forum Discussion

arvindyadav's avatar
arvindyadav
Post Partisan
6 years ago
Solved

Conditional formatting based on date where visual is matrix

Hi Team, I want to know how to do conditional formatting in power bi when dating in the column where visual is Matrix table. for example keyword ABC - is greater than any of date then it turns int...
  • Icey's avatar
    6 years ago

    Hi arvindyadav ,

    Try this:

    Measure 3 =
    RANKX (
        ALLEXCEPT ( 'Table', 'Table'[Account Manager] ),
        CALCULATE ( MAX ( 'Table'[Profit] ) ),
        ,
        DESC,
        DENSE
    )

    Hope it helps.

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.