Forum Discussion
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
- TomMartensSuper User
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
- tarochaHelper II
TomMartens
OMG as I did not know this functionality yet. Spectacular, it changes a lot for me. Thank you!- TomMartensSuper User
Hey tarocha , perfect!
- VijayPCommunity Champion