Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Domenick
Helper IV
Helper IV

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 8
Domenick
Helper IV
Helper IV

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?

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



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
Frequent Visitor

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

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

MFelix
Super User
Super User

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

Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



CoreyP
Solution Sage
Solution Sage

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

Anonymous
Not 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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors