Use slicer and text filter on single visual

[Anonymous]

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

[v-angzheng-msft]

Hi, @Anonymous 

May I ask if your problem has been solved? 

It makes it easier to give you a solution.

1. Sample (dummy dataset) data as text, use the table tool in the editing bar
2. Expected output from sample data
3. 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 Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , if you want change the measure

then a measure like

if(isfiltered(Table[Text]), [count measure], [Sum measure])

[Anonymous]

@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!