Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I have a matrix whereby I place my numeric fields in the value tab I place my year into the column tab The final result requires the column headings in the row tab. How can I achieve this thanks.
i would like to get the below result
2021 2022 Visualization tab
income 100,000 120,000 Rows
units 1000 1200 add data fields here
Columns
years
Values
income
units
but what i am getting is the following
2021 2022
income units income units
100,000 1000 120,000 1200
Solved! Go to Solution.
Found the answer after playing around in the format tab so go to visualizations -> format visual -> visual -> values -> options then turn on switch values in rows groups rather than columns
Found the answer after playing around in the format tab so go to visualizations -> format visual -> visual -> values -> options then turn on switch values in rows groups rather than columns
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 59 | |
| 46 | |
| 42 | |
| 23 | |
| 18 |
| User | Count |
|---|---|
| 193 | |
| 123 | |
| 99 | |
| 67 | |
| 49 |