Matrix Table Displaying Blanks

Question

Hi All, I have a matrix table visual where I have dropped in my Suppliers to the rows to see which ones have accounted for Deliveries. But the entire list is showing (blank values as well as two with values at the very bottom out of screen). Just wondering how I can 'hide' those suppliers without deliviers? Thanks.

1001 · Answer

Hi Rita, Thanks. I think the only way to do this successfully is for me to recreate my file with dummy data. I'll come back to this post later in the weekend when done. Thanks.&nbsp;&nbsp;

ritaf1983 · Answer

Hi&nbsp;1001&nbsp;It seems like you don't have suppliers' data on day granularity or some relationship issues.Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...Please show the expected outcome based on the sample data you provided.https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523&nbsp;&nbsp;

1001 · Answer

Hi Rita, I just discovered the main issue. The Supplier Table is connected to the Product Deliveries Table via Supplier Name, but the Supplier Names don't exist in the Product Orders Table. So when I drag the Suplier Name to the Matrix table, it's not matching it to any corresponding names in the Product Orders table, therefore displaying all the suppliers with or without delivery values. That's the issue. So now, I wonder if there's&nbsp; a measure I can write to filter out the Suppliers from the Product Deliveries table who don't have deliveries for a given date range. Does that make sense. Thanks.&nbsp;&nbsp;

ritaf1983 · Answer

Hi&nbsp;1001&nbsp;Unfortunately, I didn't understand much of your description.Except that you realized there is a problem linking tables here because there is no key.For this reason, I recommend attaching a sample file and an example of what you want to achieve.

Forum Discussion

Matrix Table Displaying Blanks

Related content

Remove Blank Rows in Matrix

Display zero instead of blank in matrix

Replace blank with 0 in matrix visual

How to Display Zero instead of Blank in Matrix Table when No Value Exists?

PowerBI - Matrix table blanks