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 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
Hi @jorismo,
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
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 |
---|---|
111 | |
95 | |
77 | |
68 | |
54 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |