Forum Discussion
Sam7
Advocate II
Advocate IIHow to edit Slicer outputs?
Hello,
How do edit my slicer output to only show those within the data?
I currently get 10 options in my slicer, but only two options are matched to my data (my slicer data is from a joined table). I don't want all options to show, what do I do? Can I deselect null results?
Thanks
S7
Sam7 , assume you slicer is from a dimension joined to a fact
Create a measure on fact
M1=countrows(Fact)
use that in visual level filter of slicer and check for non blank
1 Reply
- amitchandak
Super User
Sam7 , assume you slicer is from a dimension joined to a fact
Create a measure on fact
M1=countrows(Fact)
use that in visual level filter of slicer and check for non blank