Forum Discussion

marry's avatar
marry
Icon for Helper I rankHelper I
2 years ago
Solved

How to display several columns view using the Matrx visual

Hello,

 

I would like to display my PBI Matrx visual like below (mark in yellow---Excel sample). Mainl goal is to disply two columns but now it seems can only show one in my PBI Matrx modue.

Is there any can help on this? Thanks.

 

Excel (Sample):

PBI Current Visual: 

 

Best regards,

Mary Chen

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi marry ,

    Display the matrix visual with Multiple columns in Power BI,

    • Once the data has been loaded to the Power BI desktop, select the matrix visual from the visualizations.
    • In the Rows field, drag and drop the Accessory column field, and in the value section drag and drop the Sold Amount and Sold Qty from the field pane.
    • And In the column section, drag and drop columns that you want to display.

    Power BI Matrix Multiple Column - SPGuides

    Solved: how to display column in (Matrix or Table) visual ... - Microsoft Fabric Community

     

     

    How to Get Your Question Answered Quickly 

     

    If I have misunderstood your meaning, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Rongtie

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

     

     

     

     

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi marry ,

    Display the matrix visual with Multiple columns in Power BI,

    • Once the data has been loaded to the Power BI desktop, select the matrix visual from the visualizations.
    • In the Rows field, drag and drop the Accessory column field, and in the value section drag and drop the Sold Amount and Sold Qty from the field pane.
    • And In the column section, drag and drop columns that you want to display.

    Power BI Matrix Multiple Column - SPGuides

    Solved: how to display column in (Matrix or Table) visual ... - Microsoft Fabric Community

     

     

    How to Get Your Question Answered Quickly 

     

    If I have misunderstood your meaning, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Rongtie

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