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'm building a report that presents data for a company with multiple sites. The first page of the report contains a filter of various slicers where users can select their site and then further select what they want to see based on product codes, machines, etc. I also have built in book marks so people can quickly select their site.
We then have a page that uses two bookmark buttons where people can select if they want to see the data for the previous three days or it gives them adjustable slicers so they can pick a custom range of dates. I know the issue of doing this is the two buttons on this page overwrite the slicers from the first page so users will have to go back and re-select their plant. Is there a way around this or do I need to separate it into one page for the previous three days and then an adjustable date page.
Thanks!
@Anonymous
You have to disable data in your bookmark.
Right click the bookmark and uncheck Data.
Also, sync the slicers in those pages.
If this helps, mark it as a solution
Kudos are nice too.
Thanks, this looks good. I also left out that when the 3 day view is active, the date slicers are set to be "Relative" and hidden and then they appear and become "Between" after clicking the Adjustable button. Is this just the price to pay to be able to use this method?
@Anonymous
I can't follow you. Do you mind share a screenshot?
Basically you have to set everything and update the bookmark and save. Maybe you might have updated the bookmark with different settings?
If this helps, mark it as a solution
Kudos are nice too
Sure thing, probably didn't explain it the best.
So the default view is with the 3 Day button/bookmark active:
Here the slicers are set to relative to capture the last three days of data (but usually hidden so no one messes with them).
And the adjustable view which makes the slicers visible and turns them to the "between" option so users can select a specific date range they want to see:
When I chose not to update data on the book mark, the adjustable button still makes the slicers appear but they stay as relative date slicers.
Thanks
@Anonymous
The sync slicers option will sync the dates in 3 day/ adjustable view bookmarks.
If you are not using selected visuals option in bookmark, you should be able to view build the page as you need.
I sent a private message about this. Please check.
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |