Forum Discussion
Slicer displays values with blank data
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 s...
amitchandak
Super User
Super UserAnonymous , I doubt date range will respond. But try option this video of is using a measure from the fact to control the slicers
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?