Forum Discussion

tarocha's avatar
tarocha
Icon for Helper II rankHelper 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 o...
Need Help
  • TomMartens's avatar
    TomMartens
    5 years ago

    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

tarocha's avatar
tarocha
Icon for Helper II rankHelper II
5 years ago

TomMartens 
OMG as I did not know this functionality yet. Spectacular, it changes a lot for me. Thank you!