Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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.
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
@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
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! 😀
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |