Forum Discussion

Arvind123's avatar
Arvind123
Frequent Visitor
2 years ago

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 ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

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