Forum Discussion
Slicer Hide values w/ No Data
- Anonymous7 years ago
Hi,
I have the same problem, I have my customer table related to my Sales table, EBITDA Table and Overdue Table, when I look for a specific segment (which it's in my Customer table), the slicer show me all the customer in the segment with and without sales or overdue.
How I tried to solve this:
In my model i have tables reference to the sales, and overdue table, group by Customer ID, then I union both tables and remove duplicates. with this I have the Customer id with sales, I meger this table to my main customer table, and filter to show only values with no null values.
Hope this result for you.
this can applied in others cases.
Create a measure like INT ( NOT ISEMPTY ( FactTable ) ), use it as a visual level filter for the slicer and set it to 1.