Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Experts,
For a retail usecase, my clients have different week cycles, some want to see the data Mon to Sun or Tues to Mon and so on.
I have been trying to create a "Settings" page in the report. On this page, clients can choose their "Week cycle ends on" day. This should now change / show / hide visuals on other report pages.
Note - I have tried buttons / selection / bookmarks, but that route requires selection to be done on each report page, which is not desired.
Looking forward
Solved! Go to Solution.
Found a solution. This works
The only additional thing I did was to copy the slicers to all the pages with Sync Enabled and then "hide the copied slicer". Now the first page acts as the settings page. When I set any value there, its replicated across all pages.
Found a solution. This works
The only additional thing I did was to copy the slicers to all the pages with Sync Enabled and then "hide the copied slicer". Now the first page acts as the settings page. When I set any value there, its replicated across all pages.
Hi MontyDogar.
Maybe you can use the RLS - Row Level Security for determinate what each client can see.
look this video below, it's can help you
https://www.youtube.com/watch?v=nAePfbGOEQE
Another possibilitty is define the parameters through bookmarks associated with buttons for each customer
Look that https://www.youtube.com/watch?v=ETLxAxb3gZk
I wait to get help tou.
Best regards.
Unfortunately neither help my situation. Let me explain a bit.
On each report page I have 2 set of visualizations built using different tables. I could have used RLS if the table was same. I need to show / hide one set of graph based on the user preference.
Worst case, I will need to put a button on each report page and use bookmarks but that's inefficient. Any other possibility. Ideally I place a button on first page (settings page) and that hides one set of visuals on all report pages.
User | Count |
---|---|
76 | |
74 | |
61 | |
61 | |
45 |
User | Count |
---|---|
108 | |
103 | |
93 | |
83 | |
64 |