Button to Change or Hide Visual?

[Domenick]

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?

[Domenick]

I think these are all good solutions. I'm going to try creating two pages with a bookmark like @CoreyP suggested and hiding the other page so that they can only access it through the bookmark. That should work, right?

[v-lili6-msft]

hi @Domenick 

You could refer to this blog:

https://powerpivotpro.com/2018/04/power-bi-feature-spotlight-using-bookmark-buttons-to-create-pop-up...

or

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

Regards,

Lin

[MFelix]

Hi @Domenick ,

No need to create two pages, you can create two visual on the same page and using the bookmarks and the selection pane show/hide the visual you need.

Regards,

MFelix

[jshutters]

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.

[HadBen]

You're looking for this, but it's very tricky to constantly update.

https://docs.microsoft.com/en-us/power-bi/desktop-buttons

[MFelix]

Hi @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

[CoreyP]

You could just have your two visuals on two separate pages, then use a bookmark button that toggles between the pages.

[Anonymous]

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.