Forum Discussion

PurpleWave22's avatar
PurpleWave22
Icon for Advocate II rankAdvocate II
2 years ago
Solved

Slicer Filters Data but not Visuals

Hello,

I am having some difficulty with a slicer when used with a date table. The slicer is the date from the date table, which has a relationship with a date field in a data table. When I choose a year in the slicer, the data is filtered, but the visual is not. Image for reference: 

 

You can see the data is limited to the year selected in the slicer, but the x-axis on the graph and years in the table are not limited to that year. 

 

This is not an issue when I use the date field in the data table (not the date table), but then I'm limited in what kind of time intelligence I can do due to the dates not being acceptable as a date table.

 

Any help in obtaining the behavior I'd like would be appreciated.

Need Help

3 Replies

    • PurpleWave22's avatar
      PurpleWave22
      Icon for Advocate II rankAdvocate II
      2 years ago

      My measure is a distinct count of IDs plus 0, so it does return 0s where there are no IDs. I just removed that from my measure and it resolved the issue, but there are some situations where the 0s are useful.

       

      Is there a resolution that retains the best of both worlds where the 0s are retained but the slicer works as I expected it to?