Show Items with no data but filtered

[msarquis1]

 Hi! This is my first post. Excuse for my english!

I have a problem with the "Show Items With No data" option.

I have to tables. One with customers (where I have the customer name and which seller is in charge of every customer) and the others with the sales to this customers. They are linked by the Customer_Id.

I made this table with sales per week, customer and seller. I filter the seller with a slicer. It shows me how much I sell to them. But it doesnt show me the customers with no sales. So I use the "Show Items with no data" in the Customer_Id. 

When I use it, it brings all the customers of all the sellers, even if the slicer is selected por one particular seller. 

I couldnt find out how to solve this. Can you help?

Thank you!!

Marcos 

[v-sihou-msft · Accepted solution]

@msarquis1

I can't reproduce your issue. When using "Show Items With No data" option, it shows corresponding customers with no data based on the selection in slicer.

Can you share your .pbix if possible?

Regards,