Power BI Matrix with multiple sections

[Anonymous]

Hello All,

We have a requirement to create below matrix for our dashboard. We are able to create the matrix  but we are not able to distribute the columns into 2 sections e.g. "Daily Sales Summary" & "Sales by Category" as mentioned in below screenshot.

Could you please suggest the solution.

Thanks,

PBI V2

[Ritaf1983 · Accepted solution]

Hi @Anonymous 
You can achieve it with disconnected table and dynamic measure
Please refer to the discussion:

https://community.fabric.microsoft.com/t5/Desktop/Grouping-measures-in-a-matrix/td-p/2578237
OR with calculation groups , please refer to the video:

https://www.youtube.com/watch?v=q-zFoQfBHXM

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[Anonymous]

Hello @Ritaf1983 ,

Wow, Thanks for the elegant solution!

Thanks,

PBI V2