Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I
Helper I

Consolidate these two visuals into one - two matrix visuals with same row grouping

Hello everyone,

I've tried looking for a solution to this, but am having a bit of trouble. I have 3 columns -



Severity Type (sev 1, sev2, sev3, sev4)

Result of Change (true, false)


I want to be able to group by month and summarize counts for Severity 1 Severity 2, then have a total column for those two severities, and counts for those severities if they were due to result of change.


I am able to get the metrics I want in separate matrix visuals, but I really want these two visuals consolidated into one. The Total column and the true (result of change) column as additional columns in the same table instead of my example of two separate matrix visuals.


Just looking for guidance! Thank you in advance. 



Super User
Super User

Short of either creating a custom matrix or creating your own custom visual this is not possible.

I was actually able to accomplish this by creating a custom table based off of my main table. Thank you for the resource, my solution is similar to what's in the article/post but much simpler since my use case was more simple.


Thank you again for your response!

Helpful resources


Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors