Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. 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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
79 | |
73 | |
58 | |
36 | |
32 |
User | Count |
---|---|
90 | |
60 | |
60 | |
49 | |
45 |