Multiple Measures as rows in Cross Tab

[PBI5851]

Hello,

 I have these measures that i intend to "visualize" as a table and place them as a secondary section to a larger that aligns in the column width etc . But the only way i think of being able to do this, is to have each measure as a table on its own and do some creative formatting. But its doesnt always seem to work. 

Any recommendations on how to achieve this. All these measures are based on a calculation rather than static values.

Measure Name	Measure Value
Initial PPl Count	50
Second PPl Count	85
Third PPl Count	42
Initial State Count	5
Second State Count	9
Third State Count	3
Initial Base count	10
Second Base Count	15
Third Base Count	22

Expected Output is (ideally without column headers. My cheat code is to change font color to white). 

PPl Count	50	85	42
State Count	5	9	3
Base Count	10	15	22

[amitchandak]

@PBI5851 , You need to split the column measure name using split by delimiter "Space" on the first occurrence in power query.

And then you can use Matrix Visual

Power Query Split Column , Split Column By Delimiter: https://youtu.be/FyO9Vmhcfag

Matrix Visual: https://www.youtube.com/watch?v=M5PvQUy-L_4&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=28