Forum Discussion
Filter our N/A value in table visual
Howdy!
I was wondering if anyone had a god tip/trick for filtering our N/A values in a table visual?
Thanks!
Hi Anonymous ,
According to the screenshots, data type of DoS column seems to be Number since it could use "is greater than "option to filter value. In this case , you could not use "is not N/A".
But based on my test, when N/A exists in a column , then this column's data type is Text, so that we could use "is not N/A":
Or you could create a slicer to filter:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- amitchandak
Super User
Anonymous , put a visual level of page-level filter DOS <> "N/A"
Hi Anonymous ,
According to the screenshots, data type of DoS column seems to be Number since it could use "is greater than "option to filter value. In this case , you could not use "is not N/A".
But based on my test, when N/A exists in a column , then this column's data type is Text, so that we could use "is not N/A":
Or you could create a slicer to filter:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
