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
Hi Everyone,
I have raw data like the one below
| Name | Plan vs Actual visit (15%) | Plan vs Actual collected Invoice (15%) | Plan vs Actual collected Amount (30%) | Overdue % (20%) |
| Aung Thura | 14.36 | 14.24 | 29.32 | 13.36 |
| Hein Aung | 14.54 | 14.66 | 29.51 |
10.18 |
| Hein Thura | 13.68 | 14.22 | 29.60 | 14.82 |
| Kyaw Zin Thant | 13.99 | 14.45 | 29.43 | 13.95 |
| Mg Mg Kha | 14.24 | 14.48 | 29.21 | 11.35 |
| Nay Htun Lynn | 14.25 | 14.52 | 29.24 | 14.03 |
| Nyein Chan Kyaw | 14.53 | 14.32 | 29.29 | 15.53 |
| Nyi Nyi Lwin | 14.32 | 14.34 | 29.31 | 16.69 |
| Nyi Nyi Naing | 14.22 | 14.54 | 29.72 | 13.62 |
| Phyo Thu Aung (MLM) | 14.20 | 14.20 | 28.25 | 12.91 |
| San Nyunt Oo | 14.00 | 13.99 | 29.16 | 13.35 |
| Thiha Aung Cho | 14.01 | 14.75 | 29.58 | 13.31 |
| Wai Paing Soe (MLM) | 13.29 | 12.88 | 24.61 | 18.45 |
| Ye Yint Aung (MLM) | 14.16 | 14.21 | 28.34 | 10.86 |
| Zar Zar Khaing Lin | 14.51 | 14.53 | 29.63 | 13.07 |
| Zayar Tun (NPT) | 12.49 | 12.57 | 25.33 | 19.12 |
| Zin Nyi Nyi Tun | 13.74 | 14.09 | 29.16 | 15.93 |
and I want to show data in Power BI like the one below...
| Aung Thura | Hein Aung | Hein Thura | |
| Plan vs Actual visit (15%) | 14.36 | 14.54 | 13.68 |
| Plan vs Actual collected Invoice (15%) | 14.24 | 14.66 | 14.22 |
| Plan vs Actual collected Amount (30%) | 29.32 | 29.51 | 29.60 |
| Overdue % (20%) | 13.36 | 10.18 | 14.82 |
Solved! Go to Solution.
@Anonymous , There is an option in matrix
Switch Values to Row
or Show values on row
Nothing on row
Thanks for advice. It's works.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 35 | |
| 34 | |
| 32 | |
| 27 |
| User | Count |
|---|---|
| 136 | |
| 96 | |
| 77 | |
| 67 | |
| 65 |