Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
Hello Everyone
So i have a dataset and i want to make a table but i need to show data as vertically in table can anyone have idea how i do that i try many thing but i'm not able to do that so any help appreciate
i'll share what i want to do you can check screen shots
that's how it's look when i add on table visual but i need this
Solved! Go to Solution.
@YasirBilal , In the matrix you have the "show on row" option for the measure.
Take all other columns on values and name on column(pivot) of matrix and try with "Show on row"
https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
You can still use the matrix table for dimensions as well.
See images below:

@YasirBilal , In the matrix you have the "show on row" option for the measure.
Take all other columns on values and name on column(pivot) of matrix and try with "Show on row"
https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 22 | |
| 21 | |
| 20 | |
| 19 | |
| 13 |
| User | Count |
|---|---|
| 58 | |
| 50 | |
| 38 | |
| 31 | |
| 27 |