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
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

Highlighted
rax99 Member
Member

Re: Removing blank cells from matrix

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

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 27 members 1,081 guests
Please welcome our newest community members: