Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I am developing a Power BI report with a summary page and a detailed drill-through page. On the summary page, I have visuals like bar charts, graphs, and trees using dimensions such as Currency, Country, and Month. These dimensions are also added as drill-through filters.
Here’s the behavior I’m observing:
1. When I select a single data point in one visual, I get the drill-through option as expected.
2. When I select a single data point in multiple visuals, the drill-through option does not appear.
3. If I select one data point in one visual and multiple data points in another visual, the drill-through option works.
Is this a glitch or intended functionality in Power BI? Any insights or solutions would be greatly appreciated!”
Hi, Ritaf1983 ,thanks for your concern about this issue.
Your answer is excellent!
And I would like to share some additional solutions below.
Hello,@HarishMJ .I am glad to help you.
One thing that can be determined about the report drill-down feature is that
whether or not the drilldown function supports multiple selection of data points for a field depends on the context of the drilldown after the current field has been filtered. When you select a field, the drilldown function is valid if the current integrated computing environment can normally allow the data to be displayed properly in the visual of the drilldown page.
URL:
Fix Power BI Drill Through Not Working [6 Tested Ways]
Maybe contacting Microsoft Support could be of more help, I have a feeling this may be an issue in Power BI Desktop
This is my Desktop vsersion:
It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.
The Link of Power BI Support:
Microsoft Fabric Support and Status | Microsoft Fabric
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian
Hi @HarishMJ
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
Hi @Ritaf1983
Please access the sample file with this link.
https://drive.google.com/file/d/1nq7m9NW34pXKgEBVFum80G0KepVkE7Sq/view?usp=sharing
Hi @Ritaf1983
I am Grateful for your response. The thing is button right arrow is not active when you selected two data points in two different visuals. That was the issue.
if you select multiple visuals it will be active.
Hi @HarishMJ
Where is the problem?
I selected 1 point in 2 visuals and drill through worked as expected?
Hi @Ritaf1983
I am Grateful for your response. The thing is button right arrow is not active when you selected two data points in two different visuals. That was the issue.
if you select multiple visuals it will be active.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
85 | |
66 | |
51 | |
45 |
User | Count |
---|---|
216 | |
89 | |
82 | |
66 | |
57 |