Forum Discussion

AnandNamburi's avatar
AnandNamburi
Helper III
5 years ago
Solved

How to format a matrix table

Hi Experts,   I have a matrix table and it look like below.   Column1  Column 2 Column 3 Furniture Chair 123   Table 254   Sofa 500 Beauty Soaps 587   Shampoos  300 ...
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi AnandNamburi 

    You may want to use conditional formmatting for row headers in matrix visual.

    I build a color measure and have a test.

    Measure:

    Measure = IF(MAX('Table'[Column1])="Furniture",1,IF(MAX('Table'[Column1])="Beauty",2,3))

    Set conditional formatting in Background by Rules.

    We can use conditional formmatting to format the color in value fields in matrix visual.

    For more info to conditional formmatting, you may refer to this blog.

    Your demand is a good idea, while it is not supported to implement in Power BI currently.

    You can vote up this idea for this function:Conditional Formatting of Row Headers in Matrix

    Or you can submit a new idea to improve the Power BI.
    It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

     

    Best Regards,

    Rico Zhou

     

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