The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi Team,
Date | Category | Online offline | 1DaySales |
4/6/2021 | Equity | Online | 123 |
4/6/2021 | Equity | Online | 345 |
4/6/2021 | Equity | offline | 567 |
4/6/2021 | Equity | online | 789 |
4/6/2021 | Commodity | online | 453 |
4/6/2021 | Commodity | offline | 564 |
4/6/2021 | Currency | online | 234 |
4/5/2021 | Equity | online | 256 |
4/5/2021 | Equity | online | 0 |
4/5/2021 | Equity | online | 345 |
4/5/2021 | Equity | offline | 754 |
4/5/2021 | Commodity | online | 683 |
4/5/2021 | Commodity | online | null |
In report i have slicer Date, Category
and one toggle button(online/offline) by using bookmarks
report is working fine but when i select date 5th april and category as equity and then select online toggle butoon and then again i clicked on offline then date slicer and category selection takes different.
always my date slicer and category slicer should be sync once i select any date and then i can swith respective online offline toggle button.
and also my defualt date is alway max date when user open the report and it should be selected and other should be present in the date slicer
Solved! Go to Solution.
Is your problem that when you use bookmark, the selection will take different? Bookmark will go back to status when you create it.
Now, you have two bookmarks, online and offline. You select online, then the page will go back to the latest staus when you Update the bookmark online. You select date 5th april and category as equity in slicers. If you select offline bookmark, your page will go back to the latest staus when you Update the bookmark offline. It won't keep the selection in your slicer.
For reference: Create report bookmarks in Power BI to share insights and build stories
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Is your problem that when you use bookmark, the selection will take different? Bookmark will go back to status when you create it.
Now, you have two bookmarks, online and offline. You select online, then the page will go back to the latest staus when you Update the bookmark online. You select date 5th april and category as equity in slicers. If you select offline bookmark, your page will go back to the latest staus when you Update the bookmark offline. It won't keep the selection in your slicer.
For reference: Create report bookmarks in Power BI to share insights and build stories
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.