Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
Solved! Go to 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!
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
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
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!
@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
Indeed, This approch will also help. I thought you have already tried it. Anyways, great your problem got resolved. 🙂
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
144 | |
73 | |
64 | |
52 | |
51 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |