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

Removing blank cells from matrix



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



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;




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


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



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


rax99 Member

Re: Removing blank cells from matrix

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

Helpful resources

Community Highlights

Community Highlights

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

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 306 members 3,296 guests