Forum Discussion

tarocha's avatar
tarocha
Helper II
5 years ago
Solved

Transform measures into columns.

I created some measures but wanted them to be like rows / columns, so I can use them in a table with other dimensions.

In pbix you can see how it looks, but I wanted to make it look like the image on the print.

Is it possible to do that?

Link download Pbix 


Print how i want to do

 


Thank you




  • Hey tarocha ,

     

    use a matrix visual.

    Put the months to the columns well of the visual

    Put all measures to the values well.

     

    Finally, turn the Show on rows property in the Values well to On:

    Hopefully, this provides what you are looking for.

     

    Regards,

    Tom

4 Replies

  • Hey tarocha ,

     

    use a matrix visual.

    Put the months to the columns well of the visual

    Put all measures to the values well.

     

    Finally, turn the Show on rows property in the Values well to On:

    Hopefully, this provides what you are looking for.

     

    Regards,

    Tom