cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
skedis
Frequent Visitor

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 -

 

Date

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. 

 

 

2 REPLIES 2
lbendlin
Super User
Super User

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

 

https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...

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

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors