Forum Discussion
Helper VAll the measures in same column via switch
Hello,
I have created few measures. I want to put them in Table visual in below given criteria. I have calculated these measures through different formulas. Then I have these measures for Last year year and have same formula for last years as awell. In last I did other measure to get each of these change with year comparison.
Now I want to get them in table visual like given in below picture. I tried doing it by putting them in matrix and changing the values to rows. It works for one line of row while I want them in below given format. Is it possible to achieve it?
By putting them to matrix and changing them to rows and putting all sets of measures in different table it looks like below but I need them in the same table.
Kindly let me know it is possible to get in single able visual.
Thank you
Junaid11 , if you looking for those three in a single matrix I doubt that is possible.
3 Replies
- amitchandak
Super User
Junaid11 , if you looking for those three in a single matrix I doubt that is possible.
v-yalanwu-msftCommunity Support
Hi, Junaid11 ;
Can you post sample data as text and expected output or simple file?
Not enough information to go on;I think this can be achieved by creating measure or table.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- v-yalanwu-msft
Hi, Junaid11 ;
Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we could close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.
Best Regards,Community Support Team_ Yalan WuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.