Forum Discussion
Matrix Table Displaying Blanks
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.
4 Replies
Hi 1001
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/1447523Hi 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.
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 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.
