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...
Show and Tell
Tips and Tricks
  • 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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

This might have been solved now - make sure the slicer is selected then click slicer on the ribbon. 

Click on "Slicer Settings" and you have the option to Hide items with no data, click this and those with no info are gone 🙂

user10456's avatar
user10456
Icon for Advocate I rankAdvocate I
2 years ago

There is no "Hide items with no data" option in Slicer Settings.