Forum Discussion
lock filter (visual level filters)
Hey there, I have put in a visual filter on one of my line and cluster charts. Namely, when i view the months, the records left blank will be filtered out and not shown. However, when i drill dow...
Nhallquist
Helper V
Helper VOne thing you could do is fill in the BLANKS with a data value. For example, you can use the ISBLANK function to test if the field value is blank and if it is, add the word "BLANK" to the field. This will do two things for you. It will allow you to visually see the impact of the BLANK values, and also give you something concrete to use in your slicer.
We run into this issue often, and this is how we address it.
Good luck,
Nate