Forum Discussion
How to rearrange column in Matrix Visual.
Hi Team,
I have table like this in Power BI matrix Visual
| Project1 | Project 2 | Project 3 | ||||
| keyword | Revenue | RPC | Revenue | RPC | Revenue | RPC |
| abc | 82 | 2.00 | 90 | 1.00 | 44 | 1.00 |
| ede | 94 | 2.00 | 64 | 1.00 | 34 | 1.00 |
| efg | 90 | 2.00 | 54 | 1.00 | 78 | 2.00 |
| hij | 46 | 1.00 | 32 | 2.00 | 36 | 2.00 |
And I need to acheive table like below format:
| Project1 | Project2 | Project3 | Project1 | Project2 | Project3 | |
| keyword | Revenue | Revenue | Revenue | RPC | RPC | RPC |
| abc | 82 | 90 | 44 | 1.00 | 2.00 | 1.00 |
| ede | 94 | 64 | 34 | 1.00 | 2.00 | 1.00 |
| efg | 90 | 54 | 78 | 1.00 | 2.00 | 2.00 |
| hij | 46 | 32 | 36 | 2.00 | 1.00 | 2.00 |
How can I get this format in power bi desktop, Can someone please help me to achieve this visual.
Thanks,
Arvind
1 Reply
- amitchandak
Super User
Arvind123, Looking at the first table you need double double-header solution
How to Deal with Double Headers in Power BI: https://youtu.be/1e16oHv9kTk
For the second one, we will need a measure of the top, and for that, we need a calculation group, which is now avaiable under the Model view
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
