This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more
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
Solved! Go to Solution.
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)...
Proud to be a Super User!
Paul on Linkedin.
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)...
Proud to be a Super User!
Paul on Linkedin.
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
Hi @Evanooruvan
You say that is what your matrix looks like.
Can you show what your source data looks like?
the data is what looks like in screenshot, values has numbers
@Evanooruvan Strikes me as a custom matrix hierarchy problem. The New Hotness (Custom Matrix Hierarchy) - Microsoft Fabric Community
is there any other option without add on please
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 27 | |
| 22 | |
| 20 | |
| 18 | |
| 14 |
| User | Count |
|---|---|
| 25 | |
| 20 | |
| 20 | |
| 20 | |
| 20 |