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 nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! 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/
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 29 | |
| 27 | |
| 25 | |
| 23 | |
| 17 |
| User | Count |
|---|---|
| 54 | |
| 46 | |
| 38 | |
| 28 | |
| 21 |