How to rearrange column in Matrix Visual.

[Arvind123]

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

[amitchandak · Accepted solution]

@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