Create Subcolumns in Matrix for Actual Month and YTD

[Krexx]

Hello;
i have created a Matrix that includes 8 columns. Each of these columns are measures based on Actual Month or YTD. 

Now i would like to create some kind of Column above the measures to show Actual Month and YTD as in the image below. 

Is there any opportunity to create maybe some kind of measure groups and use them in the matrix? 

Thanks in advance

[Anonymous]

Hi @Krexx ,

To my knowledge, Matrix does not support displaying different columns/measures under Row fields.

You could create two matrix visuals respectively and then group these two visuals to get the expected output.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Krexx]

@MattAllington Hello Matt thanks for your response. It helped a lot. I have still difficulties. 

If i have 3 Measures for "Month" and 2 Measures for "YTD" then it duplicates the single measure that is only displayed in "Month" with blank values in "YTD". Do you have any idea why? 

[MattAllington]

Read my other article here. I should have posted this one the first time - sorry. https://exceleratorbi.com.au/building-a-matrix-with-asymmetrical-columns-and-rows-in-power-bi/

[MattAllington]

You can do this with disconnected tables similar to this article. https://exceleratorbi.com.au/waterfall-charts-using-measures-power-bi/

once you have the table, you can add the column to your matrix