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
trwatts
Helper I
Helper I

Help with multi year filtering

Hi Everyone. 

 

I have one set of data that is for bookings/sales that has stored information going back many years.

That data has several ways to filter to get the required information in a table.

E.g

By Store

By Product type

By Colour

And by financial period Q1, 2 3 etc. We also have some customer periods within our data. 

I have all of those options as drop downs which works really well. 

What I want to do is have the exact same set up twice on the one page where the top half drop downs control the top half and the bottom half controls the bottom half. In effect two separate tables using the same data, but being able to be filtered separately. I hope this makes sense.

 

How do I do this?

4 REPLIES 4
v-xuding-msft
Community Support
Community Support

Hi @trwatts ,

 

Have you resolved this issue? Can editing interact help you?

Change how visuals interact in a Power BI report 

 

If you have any questions, please feel free to ask us.

 

 

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mohammedadnant
Impactful Individual
Impactful Individual

@trwatts 

Proper usage of edit interaction, will help you to get this done,

 

check below video for your reference.

https://www.youtube.com/watch?v=weq7zdn-JfA

 

Thanks and hit the like button.

Mohammed Adnan

www.youtube.com/taik18

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!

Thanks & Regards,
Mohammed Adnan
Learn Power BI: https://www.youtube.com/c/taik18
amitchandak
Super User
Super User

@trwatts , I think interaction should able to help you

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

 

Half-page interacts with one set slicer and the other half interacts with another set of the slicer. make sure slicer also do not interact with each other

lkalawski
Memorable Member
Memorable Member

Hi @trwatts

This makes sense, but you need to remember to turn off interactions between filters and tables so they don't interfere with each other. If you don't, you will get blank data in most configurations.



_______________
If I helped, please accept the solution and give kudos! 😀

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.