cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

circular hierarchy

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: circular hierarchy

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.

View solution in original post

1 REPLY 1
Highlighted
Super User III
Super User III

Re: circular hierarchy

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.

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors