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?
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?
You could refer to this blog:
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.
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.
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.