Forum Discussion
Power BI Matrix with multiple sections
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
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.
2 Replies
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.