Forum Discussion
PurpleWave22
2 years agoAdvocate II
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 ...
- 2 years ago
PurpleWave22 that is the issue, check this blog post
parry2k
2 years agoSuper User
PurpleWave22 what is your measure? Are you returning 0 instead of blank?
PurpleWave22
2 years agoAdvocate II
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?