Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi All,
I want to merge two cells to have one column Header (not the values in 2 columns) using Power BI. I have the rawdata in excel that has the column header merged together but when I bring the data in power bi desktop, table doesnt look like same anymore - I want to have the result like the picture below (Mexico as the column Header and have Target and Annual as two columns under it)-
Appreciate your help
Solved! Go to Solution.
Hi @Anonymous ,
Give a try with Matrix visualization instead of Table Visual.
Thanks,
Tejaswi
Hi @Anonymous ,
Give a try with Matrix visualization instead of Table Visual.
Thanks,
Tejaswi
| User | Count |
|---|---|
| 50 | |
| 35 | |
| 29 | |
| 17 | |
| 17 |
| User | Count |
|---|---|
| 68 | |
| 56 | |
| 40 | |
| 23 | |
| 22 |