Matrix Visual: Arranging column structure

[Anonymous]

Hello Everyone,

I am trying to arrange Matrix Visual columns, so that the columns are reflecting just one Business Area for Actual or Planned Measures. It is currently showing both Actual and Planned Measures per Business Area as per below.

I need something like this for Actual measure and then the same for the planned measure in the same visual:

Also, the data is arranged in the dataset, so I cannot change the original table. Do you guys know if this could be sorted through the DAX or so? I had to blur the critical data, so hope it is okay.

[Anonymous]

Hi @amitchandak 

I understand that I will have to create a calculated group using the Tabular Editor 2.
I have requested that to be installed/get approved on my laptop. Therefore, I haven't tested it yet, so cannot say if this will work or not. 
I will post the update/accept the solution once I have been able to test/make it work using the tool you recommended.

Nevetheless, thank you for your quick reply!

[amitchandak]

@Anonymous , Based on what I got. Used Field parameter to choose one of the measures

or use a calculation group to move the measure above categorical value

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0