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
I got the following table
and the following pages
On the navigation page I have a slicer containing the ID's and a button for going to another page
I wish to be able to select an ID in the slicer and then go to the page linked to that ID in the table and keep the selected ID as filter.
If I set the action of the button to conditional page navigation I can make it go to the appropiate page, but the filtered ID isn't kept.
On the other hand, if I set the action of the button to conditional drill through I get the following message due to the fact that I have only filtered the table and doesn't have a selected data point.
Is it possible to either select the data point that is chosen in the slicer so I can use drill through or keep the filter from the slicer when using page navigation?
I would prefer to get the drill through function working
Thanks
Solved! Go to Solution.
There is a feature called "sync filters". Go to the views pane and you can select your slicer as a sync filter that's synced across report pages. Hope that makes sense!
There is a feature called "sync filters". Go to the views pane and you can select your slicer as a sync filter that's synced across report pages. Hope that makes sense!
Thanks YukiK 🙂
It made perfect sense and does the job!
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 |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |