Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not 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 that filter to the visual:

picture1.png

 

When searching for a word (e.g., 'apple') on the text filter -> show the counts on the visual:

picture2.png

 

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 3
v-angzheng-msft
Community Support
Community Support

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
Super User
Super User

@Anonymous , if you want change the measure

 

then a measure like

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

Anonymous
Not applicable

@amitchandak, Thanks! This works, but now when I use the text filter, it shows the count for every product:

RVOR_0-1647968529737.png

Whereas, I just need:

 

RVOR_1-1647968576914.png

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!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.