Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Pivot or not?

Hi,

 

Im having a issue with transforming my table. I have made a small example of the current state(left table) and the state i want it to be eventually(right table). But i just cant figure out how to make it work

 

Can someone please help me out with this?

Gr,Bas

 

 

Need Help
Show and Tell

4 Replies

  • MFelix's avatar
    MFelix
    Super User
    7 years ago

    Hi Anonymous,

     

    Use the matrix visualization to setup this look.

     

    Place X on the rows, Y on the Columns and then X on values and select the summarization as count.

     

    Regards.

    MFelix

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks for the reply, this does work!

       

      However i need it to change in the data as well, so i can put some measures over it. I want to be able to filter some row's of the table.

       

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous,

     

    Could you please mark the proper answers as solutions?

     

     

    Best Regards,
    Dale