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! It's time to submit your entry. Live now!
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.
| User | Count |
|---|---|
| 53 | |
| 37 | |
| 31 | |
| 21 | |
| 19 |
| User | Count |
|---|---|
| 138 | |
| 102 | |
| 59 | |
| 36 | |
| 35 |