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 into dark green if it is lower than the highest one then light green if it is a lower value than among both the date then it converts to red color.

 

I want format like below:

 

 

 

Thanks,

Arvind

 
Need Help
  • Icey's avatar
    Icey
    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.

19 Replies

  • Icey's avatar
    Icey
    Community Support
    6 years ago

    Hi arvindyadav ,

    Try this:

    1. Create a measure.

    Measure =
IF (
    MAX ( 'Table'[Value] )
        = CALCULATE ( MAX ( 'Table'[Value] ), ALLEXCEPT ( 'Table', 'Table'[Keyword] ) ),
    1,
    IF (
        MAX ( 'Table'[Value] )
            = CALCULATE ( MIN ( 'Table'[Value] ), ALLEXCEPT ( 'Table', 'Table'[Keyword] ) ),
        2,
        0
    )
)

    2. Set conditional formatting of Value.

     

    Best Regards,

    Icey

     

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

    • arvindyadav's avatar
      arvindyadav
      Post Partisan
      6 years ago

      Hi Icey ,

       

      Thanks for your response.

      If suppose I want to report for 7 days  11/11/2019, 11/12/2019,11/13/2019, 11/14/2019, 11/15/2019, 11/16/2019, 11/17/2019 then what was my measure and procedure?

       

      Thanks,

      Arvind.

      • Icey's avatar
        Icey
        Community Support
        6 years ago

        Hi arvindyadav ,

        For that, can you show me what you want with a screenshot just like what you post before?

         

        Best Regards,
        Icey

         

  • Icey's avatar
    Icey
    Community Support
    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.