Avoid Bookmarks from Resetting The Page

[Anonymous]

Hello,

I'm trying to build a dashboard where the user can navigate to change between charts like this

So the user can choose either to show Revenue, OPEX or PAT and the blue box will change accordingly. For this one I use bookmark method where I set for each of the button.

The problem is, for example, when user change the month and year filter, and proceed with clicking the button, it will reset the filter. I know this is because of the bookmark, where it will revert to what I set as "Update".

Is there any other way to avoid this reset issue from happening? Or is there any other method that I can use to change between charts other than bookmark?

Thank you!

[Samarth_18]

Hi @Anonymous ,

You can follow below approch to avoid it:-

1. You can create a 3 seperate page for revenue,opex,PAT and their respective visual on it. 

2 To identify which page are you on, you can highlight their respective button.

3 Now add action as "Navigation" instead of "Bookmark" and select page accordingly.

4. Before publishing to services hide other page so user will not see it as multiple pages.

Thanks,

Samarth

[Anonymous · Accepted solution]

Thank you @Samarth_18 . I was thinking about this solution too but right now the sheets are already overloaded this is not the only filter that i'm going to use. theres a lot more.

but its okay, i think i have found the solution. i discovered this filter

i can set only selected visuals that can change, so it wont affect my month/year filter.

thank you!

[APavlovs]

@Anonymous Checking Selected Visuals and disabling Data should do the trick.

I`m using the same approach here for the visual switches - https://app.powerbi.com/view?r=eyJrIjoiMjdiMmRhYTctMTdjNy00ZWFlLTkzMTMtNjUwNTVhM2FhOGQwIiwidCI6IjQ2NTRiNmYxLTBlNDctNDU3OS1hOGExLTAyZmU5ZDk0M2M3YiIsImMiOjl9&pageName=ReportSection476fdb8f7aa19d425888

[Samarth_18]

Indeed, This approch will also help. I thought you have already tried it. Anyways, great your problem got resolved. 🙂