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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
sowrk
Regular Visitor

How to make Visual level filters of one visual applied to other associated visuals

We have a table visual (visual 1) which shows data from a table in direct query mode. We have few other visuals (2,3,4) a bar chart, card, advanced card which shows some aggregated data from the same table. Visual 1 is set to interact (filter) with visuals 2,3 and 4.

 

There is a slicer on column 1 in table 1 which filters visual 1 correctly. When visual 1 changes visuals 2, 3 and 4 also refreshes and shows aggregated data as per the filter. So far everything is good.

 

Now we also have set up another slicer (Chiclet slicer) which shows 3 buttons (Year to Date, Month to Date and Week to Date). The button text comes from a temporary table column.

 

We have a Measure written which will be set to "Show" or "Hide" for each row based on the selected slicer value and the date column of the table. And we have a visual level filter on Visual 1 (Measure is "Show").

 

This works perfectly for Visual 1 which gets filtered on Slicer 2. However the associated visuals (2,3 and 4) are not getting refreshed.

 

We understand that this is because Slicer 2 doesn't directly filter table 1 but it only filters the visual. Tried setting the same visual level filter to visuals 2 ,3 and 4 but couldn't do it as these visuals show only aggregated data.

 

Is there any workaround for this problem?

1 REPLY 1
v-lili6-msft
Community Support
Community Support

hi, @sowrk 

Sample pbix file and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

Best Regards,

Lin

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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