Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Help with drill through

Hi all,

 

I've looked the instructional video 5 times, searched Google and Youtube a lot but I can't get it figured out how to do this.

 

Previous we've been working with an XLS report.

In this report there are customers with their montly SLA, these are standard collabsed. 

There is the possibility to uncollabse so that we can see the days with the sla for that day.

 

Now I want that also for my report in BI that I've created, I've tried to set up an Hierachy but I can't get it done.

What I want is that if the drill trough button is pressed an an customer is clicked the dates of the active month (today it will be December) are shown in detail.

 

I hope someone can give me an helping hand and explain how it's done.

 

 

Many many thanks    Link to BI File

Need Help

1 Reply

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous,

    If you create a hierarchy, you add it in matrix, you can see the drill down as follows(highlighted in red line).



    For your requirement, you need button, when you selected Dec month, the report will show the detailed information for Dec, when you selected Nov month, the report will show the detailed information for Nov.  If my understanding is right, we can't achieve it in Power BI to date. Please review the following feature requests and vote them.

    Create Drillthrough Reports
    Improvements to Drill-through Functionality

    Best Regards,
    Angelia