cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors