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 2Column 3
FurnitureChair123
 Table254
 Sofa500
BeautySoaps587
 Shampoos 300
 xxx458
MobilesSamsung158
 Honoe458
 Oppo977

 

Now my requirement is to format like below.

 

When I enabled Matrix my column 1 is in rows and not in Values . That's why I'm not able to achieve this directly.

 

Is there any work around for this.

 

Thanks,

Anand

Need Help
  • 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. 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi AnandNamburi 

    Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

     

    Best Regards,

    Rico Zhou