Forum Discussion
Button to Change or Hide Visual?
I want the user to be able to decide whether to see a line chart over time or year-over-year. Since it requires changing the data inputs, I need to create two separate charts that are too similar to have on separate visuals. I want to create a button that essentially toggles between the two. Anyone know of a way that I could create a button that perhaps moves the front chart to the back, thus creating the effect of changing the chart?
8 Replies
- CoreyPSolution Sage
You could just have your two visuals on two separate pages, then use a bookmark button that toggles between the pages.
- MFelixSuper UserHi Domenick,
You can make use of two different measures based on a slicer or the us off bookmarks to make it work.
https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks
Regards,
MFelix - HadBenFrequent Visitor
You're looking for this, but it's very tricky to constantly update.
- AnonymousNot applicable
Su publicación ha cambiado porque se encontró HTML no válido en el cuerpo del mensaje. El HTML no válido ha sido eliminado. Revise el mensaje y envíelo cuando esté satisfecho.
- jshuttersResolver I
I agree with MFelix that there is no need to create 2 pages. In fact, 2 pages leads to more overall maintanance (and slower performance because another page needs to be loaded). When you create the 2 visuals keep in mind the following suggestions:
+ Overlay one chart visual on top of the other, with the backgrounds turned on so they are not transparent.
+ Create 2 buttons/images. One saying, "Show Timeline" and the other saying "Show YOY" (or whatever makes sense for your context). Again, these buttons/images can be overlayed to create a toggle effect.
+ In the Selection Pane, rename the visuals and buttons to something that helps you identify with them e.g. "Button Show Timeline", "Line Chart YOY"
+ Set the action of one button/image to be a bookmark that hides one chart visual & button while making the other chart visual & button visible. And vice versa.I hope this helps.
- v-lili6-msftCommunity Support
hi Domenick
You could refer to this blog:
or
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
Regards,
Lin