Forum Discussion
Resident RockstarKeep only few filters intact while creating bookmarks
Hello all,
I want to have 3 buttons: Last Year, Last Month & Last Week, and there will be a Date Slicer(with Slider) too on the page.
So, when I select 'Last Year', it should filter the data w.r.t last 365 days, and likewise for 'Last Month' & 'Last Week' buttons.
So, the date range filter should also get filtered for the last 365 days. But, at the same time, when I switch from one button to another, it should not reset the other filters, which is the most important part.
I can do it as given in the link here, but I don't want to implement this as I would need to add many more measures, plus I want to save space taken by the intermediate table.
Can anyone please guide me how to resolve this issue? Any help would be great.
Thanks in advance.
Hello Anonymous , amitchandak and ibarrau .
Thank you for the responses. But none of the solutions provided worked for me. Instead, I followed this link here.
This wasn't pretty much crisp and clear understanding it. If anyone does have any problem, feel free to reach me anytime.
It is really sad that none of the links were useful or helpful for this. Or even to show how 'All Visuals' & 'Selected Visuals' works or how to implement it.
6 Replies
- ibarrau
Super User
Hi. This might sound like a lazy answer but did you try the relative date slicer?
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
This way you can filter by last N period, so you can do like last 1 week or last 1 month, etc. Then you can edit interactions to avoid filtering the other filters.
Hope this helps, I think is the only way to keep it simple, otherwise you have to play with DAX.
Regards
- ibarrau
Well if you don't want the DAX way you have shown or the date slicer you may be able to do it generating bookmark buttons. You can hide and show different visualizations for last year, month and week depending on the bookmark state.
You chan check the toggle button idea of this post but instead of doing an on/off switch it would be three buttons to pick up.
https://community.powerbi.com/t5/Community-Blog/Three-Killer-Ways-to-Use-Bookmarks/ba-p/870816
Regards,
- amitchandak
rajulshah , I think you have a very similar solution. But still, check if this can help
Hi rajulshahm,
Nope, I don't think you can keep the current filter effect when you enabled to restore the filter effect that stored in a bookmark.
I'd like to suggest you direct use filter/slicer to achieve this instead of use a bookmark.
For example: create an attribute filter to interaction with visuals.
Dynamic Attributes In A Power BI Report
Regards,
Xiaoxin Sheng
rajulshahHello Anonymous , amitchandak and ibarrau .
Thank you for the responses. But none of the solutions provided worked for me. Instead, I followed this link here.
This wasn't pretty much crisp and clear understanding it. If anyone does have any problem, feel free to reach me anytime.
It is really sad that none of the links were useful or helpful for this. Or even to show how 'All Visuals' & 'Selected Visuals' works or how to implement it.
