Forum Discussion
Anonymous
4 years agoNot applicable
Use slicer and text filter on single visual
Hi everyone, Currently I'm stumbling on an issue integrating a slicer and text filter functions. I would like to to the following: When selecting an item (e.g., Store A) on the slicer -> apply t...
amitchandak
Super User
4 years agoAnonymous , if you want change the measure
then a measure like
if(isfiltered(Table[Text]), [count measure], [Sum measure])
Anonymous
4 years agoNot applicable
amitchandak, Thanks! This works, but now when I use the text filter, it shows the count for every product:
Whereas, I just need:
Also, in order to use the slicer again, I need to manually clear the text filter first. Is there perhaps a way where I can still use 2 visuals (one for the slicer and one for the text filter), but hide the one that is not used? (e.g., when using the slicer, hide the text filter visual and vice versa).
Thanks again!