Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

How to Combine multiple Columns in a single matrix

I have 4 different measures that are calculating SUM of columns of same tables.  And i wanted to display them in a matrix.

Can you please help on this ...

Screenshot 1:
The first screenshot below is how it looks like when i try to display them. 



 

I need to display in below format:

 

 

Need Help

2 Replies

  • Daniel29195's avatar
    Daniel29195
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Anonymous 

    power bi automatically order the columns in asc order. 

    so it should be from a to b . 

    try removing the column and then drag it again to the visual. 

     

    try removing the sorting order on the visual. 

     

    let me know if this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

    As Daniel29195  said, in Power BI Desktop it gives you automatic alphabetical sorting. One thing I am more curious about is what form your data is in. I tried to restore your matrix, but I found I couldn't.

    If you could provide your specific data, I think that would be better.

     

     

     

    Best Regards

    Yilong Zhou

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