Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Slicer Hide values w/ No Data

  Slicer = Sub Account No. (Departments) filtering current year spend by department. Currently the slicer is showing departments with no current year spend. How can I hide these departments to reduc...
  • Anonymous's avatar
    Anonymous
    7 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.