The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi Community,
Please assist me with below issue .
I have a summary tab as shown in screen shot . I also have details related to the measures i am showing in summary tab in a different tab called Details tab.
Summary tab :
Details tab :
Requirement is to see what are those 36.97% of records or 7.5 % of records or 55.41 % of records that are accoutable . When i right click on that yellow part (measure ) in summary tab and click on drill through , it should show only those 36.97% of records in details tab. With the way i have configured drill through as of now, it is drilling through . However, it is showing all the records instead of only those 36.97% of records.
- Can we drill through from a measure in summary tab to details tab ? if yes, please assist me on how to configure drill through to make it work .
G Venkatesh
@Anonymous , Measure will not pass filter used inside the measure to drill down. On filter/slicer on-page and parameter of visual will be passed
So use the measure in drill visual or add an additional filter.
Also, check of conditional drill down can help
https://visualbi.com/blogs/microsoft/powerbi/conditionally-drill-action-power-bi/
https://www.havensconsulting.net/blog-and-media/conditional-drillthrough-navigation-for-buttons
THanks Amit . I will try that
Hi, @Anonymous
Could you please tell me whether your problem has been solved?
If yes, you could accept the helpful answer as solution. You could also share your own solution here.
For now, there is no content of description in the thread. If you still need help, please share more details to us.
Best Regards,
Community Support Team _ Eason
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
248 | |
123 | |
111 | |
78 | |
74 |