Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Matrix/Table Visual with measures only

Hi All,

 

I want to build below table/matrix visual, they are currently in excel.

Each of the values are measures, there is not any column pulled from the table. I want to create below view in power bi, also this should respect the slicers applied on the page. I pulled all of them in cards individually and they are working with respect to slicer selection but I need the same in table format.

 

 

Need Help

5 Replies

  • Prateek97's avatar
    Prateek97
    Resolver III
    3 years ago

    Hi Anonymous ,

     

    You can try switching on the below option - "Switch Values to Rows", which gives the name of the values/measures in the rows, while you can have the category in your columns.

    Please mark this as a solution, if it works.

     

    Thank you!

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Sorry it won't work.

     

    there is not any table values to be pulled in column field of matrix. Every value you see in the screenshot is coming from measure. Cat1, Cat2 these are measures.

    • Prateek97's avatar
      Prateek97
      Resolver III
      3 years ago

      Hi Anonymous ,

       

      If Cat1, Cat2, Cat3, All are measures, Then what are the values in the rows. That must be a column coming from aany table

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        There was not any column, I created one table with Cat1, Cat2 etc. I will use selectedvalue to show data.