cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rax99 Member
Member

Removing blank cells from matrix

Hi,

 

So I have the following table set up which is just 2 fact tables and 2 dimensional table

 

captables.JPG

I need a matrix view to show list of clients, and for each one show the total SUM of Talk times, Ring times, and Hold times (Hold split into attempt, cold, warm), a bit like this;

 

matrixcorrect.JPG

 

Iv tried to build this in power bi but running into some problems. For example my matrix is appearing like this:

matrix_test.JPG

As you can see there are blank cells where there are no values (eg there should be no ringtime for Outbound-->Hold). So, although its showing a blank cell, I need this entire column (Outbound->Hold->Ring) to not appear in the matrix as Ring does not belong to Hold. And AttemptHold, WarmHold does not belong in Ring.

 

How can this be acheived?

 

I have also inlcuded the example pbix file here

 

Thanks

2 REPLIES 2
Highlighted
Community Support Team
Community Support Team

Re: Removing blank cells from matrix

Hi @rax99 

Unfortunately, it is not possible to remove columns in a matrix as you expected.

To get your desired output, we may work with some workarounds.

I will give my solution as soon as i figure out.

 

Best Regards

Maggie

rax99 Member
Member

Re: Removing blank cells from matrix

thanks @v-juanli-msft I will await your findings Smiley Happy 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 6 members 1,708 guests
Please welcome our newest community members: