Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

No Conditional Formatting on Matrix rows

While using a Power BI Matrix a cannot do conditional formatting on Rows, However the same option is available when we use a Table. Also I would like Power BI Conditional Formatting to support Replace Text feature as in other BI Tools.

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks rajulshah but this seems to be a work around with Table. However in my scenario I want to achieve the same on Matrix because data needs to be pivoted.

      Matrix too does support conditional formatting on Values only. But unfortunately not for Rows.

  • Icey's avatar
    Icey
    Community Support

    Hi Anonymous ,

    Please show me an example and I'll conduct specific tests. Maybe there is one workaround.

     

    Best Regards,

    Icey

    • Anonymous's avatar
      Anonymous
      Not applicable

      Icey 

      This is a default Matrix

      Default Matrix

      It has conditional formatting feature availabe with Values as EventScore & KmDriven

      Conditional Formatting available for Values only

      But at the same time it has no Conditional Formatting feature for Rows like Driver, BlueKey, Badge etc.

      Formatting not available for Rows

       

       

       

       

      • Icey's avatar
        Icey
        Community Support

        Hi Anonymous ,

        Based on my test, Power BI does not support it currently. And I find no workaround until now.

        Please share your ideas on Power BI Ideas, where customers can provide feedback about Power BI to improve it.

         

         

        Best Regards,

        Icey

         

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