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

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
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!