Forum Discussion
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
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
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
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.
