{"id":177923,"date":"2024-02-15T11:48:58","date_gmt":"2024-02-15T10:48:58","guid":{"rendered":"https:\/\/liora.io\/en\/?p=177923"},"modified":"2026-08-05T11:11:41","modified_gmt":"2026-08-05T10:11:41","slug":"drillthrough-power-bi-how-do-i-use-this-feature","status":"publish","type":"post","link":"https:\/\/liora.io\/en\/drillthrough-power-bi-how-do-i-use-this-feature","title":{"rendered":"Drillthrough Power BI: How do I use this feature?"},"content":{"rendered":"\n<p><strong>The Drillthrough Power BI feature allow you to add a page dedicated to a specific entity within a report, in order to present it with in-depth data visualizations. Find out everything you need to know about this useful tool, and how to take a training course to master Power BI in its entirety.<\/strong><\/p>\n\n\n\n<p><strong>Microsoft&#8217;s Power BI software<\/strong> is without doubt the most <a href=\"https:\/\/liora.io\/en\/the-use-of-power-bi-in-start-ups\">popular Business Intelligence tool in the enterprise.<\/a> This platform enables you to analyze data from a multitude of sources, and create reports and dashboards, complete with visualizations.<\/p>\n\n\n\n<p>One of Power BI&#8217;s strong points is the Drillthrough function, which enables you to create a page dedicated to a <a href=\"https:\/\/liora.io\/en\/unlocking-insights-power-bi-sample-reports\">specific entity in a Power BI report<\/a>. This entity can be a customer, a supplier or even a manufacturer.<\/p>\n\n\n\n<p>This method is ideal for taking an in-depth look at a specific component, and aggregating actionable information.<\/p>\n\n\n\n<div class=\"wp-block-group has-background has-global-padding is-layout-constrained wp-container-core-group-is-layout-7441ce17 wp-block-group-is-layout-constrained\" style=\"border-left-color:#ff5c43;border-left-width:4px;border-radius:12px;background-color:#fff5f2;margin-top:32px;margin-bottom:32px;padding-top:24px;padding-right:28px;padding-bottom:24px;padding-left:28px\">\n\n<p style=\"margin-top:0;margin-bottom:16px;font-size:clamp(14.642px, 0.915rem + ((1vw - 3.2px) * 0.575), 22px);font-style:normal;font-weight:600\">Related articles<\/p>\n\n\n\n<ul style=\"margin-top:0;margin-bottom:0;padding-left:20px\" class=\"wp-block-list\">\n<li><a href=\"https:\/\/liora.io\/en\/dax-power-bi-all-about-the-query-programming-language\" rel=\"noopener\" target=\"_blank\">DAX Power BI: all about the query programming language<\/a><\/li><li><a href=\"https:\/\/liora.io\/en\/dataflow-power-bi-everything-you-need-to-know-about-the-self-service-etl-tool\" rel=\"noopener\" target=\"_blank\">Dataflow Power BI: everything you need to know about the self-service ETL tool<\/a><\/li><li><a href=\"https:\/\/liora.io\/en\/power-bi-direct-query-all-you-need-to-know-about-this-data-query-method\" rel=\"noopener\" target=\"_blank\">Power BI Direct Query: All you need to know about this data query method <\/a><\/li><li><a href=\"https:\/\/liora.io\/en\/power-bi-license-how-much-does-the-microsoft-solution-cost\" rel=\"noopener\" target=\"_blank\">Power BI license: What does it cost? <\/a><\/li><li><a href=\"https:\/\/liora.io\/en\/power-bi-vs-tableau\" rel=\"noopener\" target=\"_blank\">Power BI vs. Tableau: Two tools <\/a><\/li>\n<\/ul>\n\n<\/div>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex is-content-justification-center wp-container-core-buttons-is-layout-5ee10de4\" style=\"margin-top:32px;margin-bottom:32px\"><div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"\/en\/courses\/data-ai\/power-bi\">Discover our Power BI training<\/a><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"what-is-power-bi\">What is Power BI?<\/h2>\n\n\n\n<p><a href=\"https:\/\/liora.io\/en\/power-bi-for-retail-whats-at-stake-and-whats-the-outlook\">Power BI<\/a> is a Business Intelligence platform developed by Microsoft. It offers data analysis and visualization functionalities, through a very simple and intuitive interface.<\/p>\n\n\n\n<p>This software suite makes it possible to collect data from a wide range of sources, present it in the form of visualizations and share it. A wide variety of graphs and charts can be used to visualize data and create interactive dashboards.<\/p>\n\n\n\n<p>Many companies around the world use <strong>Power BI<\/strong> for its integration with<strong> Microsoft products and services.<\/strong> What&#8217;s more, this software enables real-time analysis of data streams for better decision-making.<\/p>\n\n\n\n<p>The<strong> Power BI platform<\/strong> is available as PC software, a mobile application and as a Microsoft Azure cloud service. Data and tools can therefore be accessed from any device.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\" style=\"margin-top:32px;margin-bottom:32px\"><img alt=\"Illustration for What is Power BI?\" decoding=\"async\" height=\"539\" loading=\"lazy\" src=\"https:\/\/liora.io\/app\/uploads\/2022\/09\/power-bi-1.jpg\" style=\"width:100%;height:auto\" width=\"1407\"\/><\/figure>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex is-content-justification-center wp-container-core-buttons-is-layout-5ee10de4\" style=\"margin-top:32px;margin-bottom:32px\"><div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"\/en\/courses\/data-ai\/power-bi\">Power BI certification course<\/a><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"what-is-power-bi-drillthrough\">What is Power BI Drillthrough?<\/h2>\n\n\n\n<p><strong>Power BI&#8217;s Drillthrough<\/strong> feature allows you to delve deeper into the details of a specific type of data or value displayed in a report.<\/p>\n\n\n\n<p>It lets you explore the different layers of data in a dataset, and move from one report to another while continuing to analyze the <a href=\"https:\/\/liora.io\/en\/datasets-top-5-places-to-find-quality-datasets\">same data set.<\/a><\/p>\n\n\n\n<p>For example, a tabular report on sales data can be enhanced with a button allowing users to toggle between an analysis grid or a heat map to <a href=\"https:\/\/liora.io\/en\/what-is-a-dataset-how-do-i-work-with-it\">view the same dataset.<\/a><\/p>\n\n\n\n<p>In this way, <strong>Power BI Drillthrough<\/strong> is essential for gaining a comprehensive understanding of data. It allows the same data to be analyzed with different visualization features and methods, rather than being limited to a single report.<\/p>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex is-content-justification-center wp-container-core-buttons-is-layout-5ee10de4\" style=\"margin-top:32px;margin-bottom:32px\"><div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"\/en\/courses\/data-ai\/power-bi\">Learn to master Power BI<\/a><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"how-to-use-power-bi-drillthrough\">How to use Power BI Drillthrough<\/h2>\n\n\n\n<p>To use <strong>Power BI Drillthrough<\/strong>, simply right-click on a data point on the report page you&#8217;re interested in. You can then &#8220;drill through&#8221; to the focused page to obtain the details you&#8217;re looking for.<\/p>\n\n\n\n<p>However, it is first necessary to configure <strong>Power BI Drillthrough.<\/strong> This can be done on any report from <a href=\"https:\/\/liora.io\/en\/power-bi-desktop-download-and-installation-guide\">Power BI Desktop or Service.<\/a><\/p>\n\n\n\n<p>First, you need to define a &#8220;master report&#8221; for your target report from the reports tab. You can then build multiple <strong>Power BI Drillthrough<\/strong> reports.<\/p>\n\n\n\n<p>To define the destination page, start by creating a report page containing the visuals for the entity concerned by the Drillthrough. For example, if the <strong>Power BI Drillthrough<\/strong> is for manufacturers, the page will contain visuals showing the total number of units shipped, total sales, sales by region or sales by category.<\/p>\n\n\n\n<p>When the user performs a <strong>Power BI Drillthrough<\/strong> to this page, he or she will be able to observe these specific visuals. On the Drillthrough page, remember to add the field in the slot below the visualization panel.<\/p>\n\n\n\n<p><a href=\"https:\/\/liora.io\/en\/power-bi-mobile-everything-you-need-to-know-about-the-mobile-version-of-power-bi\">Power BI<\/a> automatically creates a back button visual that functions as a button in published <strong>Power BI reports<\/strong>. It allows users to return to the main report page.<\/p>\n\n\n\n<p>This back button is present as an image, and can therefore be replaced by the visual of your choice. Simply go to the Home tab, click on &#8220;Image&#8221; and choose an image to place on the Drillthrough page.<\/p>\n\n\n\n<p>Then go to &#8220;Format&#8221;, choose &#8220;Image&#8221; and activate the &#8220;Action&#8221; switch. Choose &#8220;Back&#8221; as action &#8220;Type&#8221;. The selected image is now used as a back button.<\/p>\n\n\n\n<p>At any time, users can now right-click on a data point in the report to display a context menu with the <strong>Power BI Drillthrough<\/strong> for that page. This allows them to view information and visualizations on the selected data point.<\/p>\n\n\n\n<p>Note that any filters applied can be transferred to the<strong> Power BI Drillthrough<\/strong> window. For example, if a user uses filters for only a certain product category in a report, they can retain this filtering when displaying the Drillthrough.<\/p>\n\n\n\n<p>To enable the retention of applied filters, go to the Drillthrough section of the visualization panel and activate the &#8220;Keep all filters&#8221; option by setting the switch to &#8220;On&#8221;.<\/p>\n\n\n\n<p>When drilling down to a visual, you can consult the list of applied filters. They are shown in italics in the Drillthrough section of the control panel.<\/p>\n\n\n\n<p>Another <strong>Power BI feature is &#8220;Drillthrough Cross-Report&#8221;.<\/strong> This allows you to connect several reports with related content, so you can easily switch from one to the other.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\" style=\"margin-top:32px;margin-bottom:32px\"><img alt=\"Illustration for How to use Power BI Drillthrough\" decoding=\"async\" height=\"479\" loading=\"lazy\" src=\"https:\/\/liora.io\/app\/uploads\/2022\/09\/crossreportdrillthrough.jpg\" style=\"width:100%;height:auto\" width=\"936\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"how-do-i-learn-to-use-power-bi\">How do I learn to use Power BI?<\/h2>\n\n\n\n<p>Now you know how to use the<strong> Power BI Drillthrough<\/strong> feature. However, this is just one of the many subtleties of Power BI!<\/p>\n\n\n\n<p>If you want to learn how to use this software to the full, Liora is the place to be. Our <a href=\"https:\/\/liora.io\/en\/power-bi-traininghttps:\/\/liora.io\/en\/power-bi-training\">Power BI training course<\/a> enables beginners to fully master the platform in just five days.<\/p>\n\n\n\n<p>The entire course lasts 38 hours. However, beginners can be satisfied with the three-day introductory course, and advanced users can go straight into the two-day in-depth program.<\/p>\n\n\n\n<p>Through this course, you will learn to handle the various facets of <a href=\"https:\/\/liora.io\/en\/dax-power-bi-all-about-the-query-programming-language\">Power BI, such as the Power Query engine, the DAX language,<\/a> data modeling and DataViz. You&#8217;ll be able to analyze data, visualize it and create dashboards.<\/p>\n\n\n\n<p>As a <strong>Microsoft Learning Partner,<\/strong> Liora is authorized to prepare and administer the PL-300 exam. This test leads to official Microsoft Power BI Data Analyst Associate certification!<\/p>\n\n\n\n<p>Our government-recognized organization is eligible for funding options and our program is entirely distance learning via the Internet. To learn how to use Power BI, discover Liora now!<\/p>\n\n\n\n<p>Now you know all about Drillthrough Power BI. For more information on the same subject, take a look at our complete dossier on the <a href=\"https:\/\/liora.io\/en\/dax-studio-everything-you-need-to-know-about-the-dax-language-query-analysis-tool\">DAX language.<\/a><\/p>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex is-content-justification-center wp-container-core-buttons-is-layout-5ee10de4\" style=\"margin-top:32px;margin-bottom:32px\"><div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"\/en\/courses\/data-ai\/power-bi\">Discover our Power BI training<\/a><\/div><\/div>\n\n","protected":false},"excerpt":{"rendered":"<p>The Drillthrough Power BI feature allow you to add a page dedicated to a specific entity within a report, in order to present it with in-depth data visualizations. Find out everything you need to know about this useful tool, and how to take a training course to master Power BI in its entirety. Microsoft&#8217;s Power [&hellip;]<\/p>\n","protected":false},"author":76,"featured_media":177936,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"_acf_changed":false,"editor_notices":[],"footnotes":""},"categories":[2433],"class_list":["post-177923","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-ai"],"acf":[],"_links":{"self":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts\/177923","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/users\/76"}],"replies":[{"embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/comments?post=177923"}],"version-history":[{"count":3,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts\/177923\/revisions"}],"predecessor-version":[{"id":209545,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts\/177923\/revisions\/209545"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/media\/177936"}],"wp:attachment":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/media?parent=177923"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/categories?post=177923"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}