Keep only few filters intact while creating bookmarks

[rajulshah]

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.

[v-shex-msft]

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

[rajulshah · Accepted solution]

Hello @v-shex-msft , @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.

[amitchandak]

@rajulshah , I think you have a very similar solution. But still, check if this can help

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

[ibarrau]

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

[rajulshah]

Thank you for the response @ibarrau .

I don't want the users to play with the Date Slicer as we would have many users and not proper training management for the users. So I want it to be very simple, straightforward & easy for the users to use.

Any other options may work!? 

[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,