Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Guys,
I am creating a dashboard where I have Revenues set out against a hierarchy, Month and then date.
I have gotten to the level where if you click on a certain month, you will drill down to the days of said month.
However, I want it to be able to revert this drill down with a single click in the graph, as most of my audience is not familiar with Power BI. Is this possible? I was thinking it might be possible with a button, but I couldnt work it out.
Thanks in advance
Solved! Go to Solution.
If you have multiple columns in a chart to enable drill down there should be drill up/down arrows when the users hover over the chart. So one option would be to teach your users how to use these.
But you could do a similar thing with a button control. From the view menu turn on the bookmarks pane, then create a bookmark with your chart in it's initial state. Then add a button and set it's action property to link to the bookmark you just created. Then whenever your users click on the button the state of the page should return to state you saved when you created the bookmark.
If you have multiple columns in a chart to enable drill down there should be drill up/down arrows when the users hover over the chart. So one option would be to teach your users how to use these.
But you could do a similar thing with a button control. From the view menu turn on the bookmarks pane, then create a bookmark with your chart in it's initial state. Then add a button and set it's action property to link to the bookmark you just created. Then whenever your users click on the button the state of the page should return to state you saved when you created the bookmark.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |