Forum Discussion
Convert value column into rows
Here is how my matrix looks
with total and percent being values and payment column in rows
How to bring my values column into rows like this
can someone help with this, how it can be done
PaulDBrownyour help would be greatly appreciated if possible
Thank you
If your "Total" and "percent" are measures, it should be as simple as turning on the option to show values on rows. You will find it under "Values"/ Options in the formatting pane.
(Apologies since I cannot post images since I seem to have exceeded my limit)...
6 Replies
- PaulDBrownCommunity Champion
If your "Total" and "percent" are measures, it should be as simple as turning on the option to show values on rows. You will find it under "Values"/ Options in the formatting pane.
(Apologies since I cannot post images since I seem to have exceeded my limit)...
- EvanooruvanHelper II
thank you 🙂 it helped
you have helped in many use cases without you i would have been stuck many times.
Please create new account 🙂 your gifs are really helpful
- Greg_DecklerCommunity Champion
Evanooruvan Strikes me as a custom matrix hierarchy problem. The New Hotness (Custom Matrix Hierarchy) - Microsoft Fabric Community
- EvanooruvanHelper II
is there any other option without add on please
- gmsambornSuper User
Hi Evanooruvan
You say that is what your matrix looks like.
Can you show what your source data looks like?
- EvanooruvanHelper II
the data is what looks like in screenshot, values has numbers