Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Matrix Visual: Arranging column structure

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.

 

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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!