Slicer displays values with blank data

[Anonymous]

Hi,

I have 3 dimension tables (Date, SalesForce and Subjects) and 1 fact table (Fact Sales Invoice).

I have a page where I want to display the sales invoice net amount by Client (showing also the sales force and margins)

I want to filter by date, by macrocat (a field in the fact sales invoices rows), by sales force and by subject (customer). So I added 4 slicers, one for each above-mentioned fields.

I linked the filters to make them interact with each other, but here is the problem:

when I make a selection on all slicer, there are customers that don't have any net amount to display in the range of date selected , but are present in the customer slicer (because they have some net amount in another range of date that is not selected):

In this way there are customers that are displayed in the slicer even if they don't have any net amount in the range selected. How can I make them disappear when there is no net amount in the range selected? I tried to insert a filter "Net amount is not blank" in the final visual, but the customer continues to appear in the slicer. Here you can see that this customer has net amount in another range of date:

thanks

[Anonymous]

@Anonymous 

Is it possible to share a sample pbix, so we can test out?

Paul Zheng _ Community Support Team

[amitchandak]

@Anonymous , I doubt date range will respond. But try option this video of is using a measure from the fact to control the slicers

refer: https://www.youtube.com/watch?v=cyOquvfhzNM

[Anonymous]

Hi and thanks for your answer. I've seen the video and I tried to create a SUM measure with a filter on date in it:

Misura per filtro slicer = CALCULATE(SUM('F - Sales invoice'[Net amount in company currency]), 'D - Date'[Date])

and i set on the slicer greater than 0, but it doesn't hide the customer with no data. Any other ideas?