Reset button to reset visual at specfic level while drilling

[mwadhwani]

Hello Experts,

 I have created a report in which bar graph showcase Metric value against DateTime Hierarchy(Year->Quarter->Month->Day->Hour->Minute).

On X-axis I have user hierarchy i.e DateTime, on y-axis metric.

I have drill down functionality enabled. I want a button, when clicked will always show data at month level.

Right now if I save report at drilling till month level and publish it to Power Bi Service, it shows data at month level.But when I drill it to Hour level(in Power BI Service) then I wanted a reset button which should reset the visual to month level.

I dont know whether its feasible or not? Please suggest me if there is any way or workaround to achieve this functionality.

Thanks in advance!!

[v-qiuyu-msft · Accepted solution]

Hi @mwadhwani,

In your scenario, as you save the report drill through to month level, once you drill up/down to another level, you can just refresh the browser page, it will display drill through to month level as original version. If you do not save the report after you change drill through level, every time you refresh the browser page, it will back to the saved status.  

Best Regards,
Qiuyun Yu 

[mwadhwani]

Thank you @v-qiuyu-msft for the help.

Its working ..!!

[Anonymous]

Hi @mwadhwani,

Can't you make a slicer with a button "Month"that when you click it, it will automatically show on Month level.

(I have'nt tried it myself, so just an idea)

L.Meijdam

[mwadhwani]

Thanks @Anonymous for the reply.

I tried it by creating slicer but drill level does not show the data at month level.

I mean if I drill to Hour and then I select Month from slicer it shows Hour Vs Metric for all the months of all years aggregated, it doesen't get drilled up automatically to month level.