Forum Discussion
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 that filter to the visual:
When searching for a word (e.g., 'apple') on the text filter -> show the counts on the visual:
Both tasks are easy to implement when using separate visuals; however, I would like to use one and the same visual (or at least hide the one that is not used).
Does anyone know how I can visualize the results showing only one visual at a time?
Thanks!
Robert
3 Replies
- amitchandak
Super User
Anonymous , if you want change the measure
then a measure like
if(isfiltered(Table[Text]), [count measure], [Sum measure])
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!
- v-angzheng-msft
Community Support
Hi, Anonymous
May I ask if your problem has been solved?
It makes it easier to give you a solution.
- Sample (dummy dataset) data as text, use the table tool in the editing bar
- Expected output from sample data
- Explanation in words of how to get from 1. to 2.
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _ Zeon ZhengIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
