Matrix measures with multiple groups and color formatting

[pbidaxlearner]

Hi Experts,

Im trying to build matrix visual with 3 groups subtiles - Group1- Sales,Group2 - Qty,Group3 - Margin  it has mutiple measures and need to show product data for year and month level for those measures and also color formatting, Please help me with this.

@amitchandak  @Greg @ashish Could you please share some ideas.

[Ritaf1983 · Accepted solution]

Hi @pbidaxlearner 

You can achieve the desired results by using a disconnected table and dynamic measure .

Please refer to the linked discussion:

https://community.fabric.microsoft.com/t5/Desktop/Grouping-measures-in-a-matrix/td-p/2578237

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