Forum Discussion
Solved
PBI reports change dynamically based on user preference
Hi, I have a large SQL table which looks like below and associated tables. I have provided a dashboard having 6 reports for different aspects for prod type A. Now my user wants the same set of...
Hi luckygirl ,
- Add a ProdType slicer and synchronize it only across report pages where users need consistent selections. Avoid syncing to pages requiring different ProdType selections.
- Create a dynamic parameter for ProdType and use it in queries within DirectQuery or Power Query mode. Filtering the dataset at the source level is recommended to enhance load times.
- If users frequently switch between ProdTypes, set up bookmarks with preset selections and add buttons for easy toggling between these bookmarks.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks. The Dashboard has 6 reports. I can't ask the user to select type 6 times. He might select Type A in one report and still look at the figures for Type B in another report.
Hi luckygirl ,
- Add a ProdType slicer and synchronize it only across report pages where users need consistent selections. Avoid syncing to pages requiring different ProdType selections.
- Create a dynamic parameter for ProdType and use it in queries within DirectQuery or Power Query mode. Filtering the dataset at the source level is recommended to enhance load times.
- If users frequently switch between ProdTypes, set up bookmarks with preset selections and add buttons for easy toggling between these bookmarks.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks, 1 one is doable. I am using import mode and hence 2 is not possible. Thanks