Forum Discussion

Abhijsrwala1's avatar
Abhijsrwala1
Frequent Visitor
4 years ago

Need Help In matrix visual

Hi all,

How do I create below matrix ? the rows qty, sales,GP are different columns which are used as rows. 

Tips and Tricks

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Abhijsrwala1  ,Check if "show on row" in Matrix Visual, can help. That will bring measures to row.

     

    If you need a measure to dimension conversion. You can use calculation group

    Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Community Support
    4 years ago

    Hi Abhijsrwala1 ,

     

    To customize the creation of the matrix, you need to create two tables, one containing only the row names, one containing the column names, and one measure for switching the measure of the current row

    Pbix file in the end you can refer.

    Best Regards

    Community Support Team _ chenwu zhu

     

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