This is how you can disable drill down in Power BI [SOLVED]

by Milan Stanojevic
Milan Stanojevic
Milan Stanojevic
Windows & Software Expert
Milan has been enthusiastic about PCs ever since his childhood days, and this led him to take interest in all PC-related technologies. Before joining WindowsReport, he worked as... read more
Affiliate Disclosure
power bi disable drill down
XINSTALL BY CLICKING THE DOWNLOAD FILE
To fix various PC problems, we recommend DriverFix:
This software will keep your drivers up and running, thus keeping you safe from common computer errors and hardware failure. Check all your drivers now in 3 easy steps:

  1. Download DriverFix (verified download file).
  2. Click Start Scan to find all problematic drivers.
  3. Click Update Drivers to get new versions and avoid system malfunctionings.
  • DriverFix has been downloaded by 0 readers this month.

Through the drill down feature, Power BI allows users to add multiple hierarchies. In this way, you’ll have a good insight into your data.

Sometimes, users can opt to disable the drill down option, but this brings issues for quite a few people.

One user reported the following:

Can anyone tell me how to disable the drill on options in the matrix as shown in the image below;

power bi drill down example
So, the OP wants to disable the drill down option (and the hierarchy with it). This operation is unknown to many users, but fortunately, there is a very simple solution. Today we will discuss how to disable the drill down option in Power BI.

Steps to disable drill down in Power BI

  1. Click on the Format panel.
  2. Turn off Visual header.power bi drill down visual header

It is worth mentioning that the option will still be visible in Power BI Desktop because you are in editor mode, but you will see the changes in the reading mode.


We’ve written a nice piece about Power BI, do check it out.


In many cases, the drill down option is extremely useful

Generally speaking, a well-organized piece of information is much easier to understand, and to order information efficiently means creating a hierarchy.

We write hierarchically: we have a heading, a subheading, smaller subheadings, and the text. Also, you pinpoint a geographical location by referring to the country, county, city, street and so on.

So, it is understandable that hierarchy plays a major role in Power BI. Moreover, the drill down feature takes you to the next step in the hierarchical organization of data.

With this option, you can add new levels of information that will allow you to create complex sets of data, such as treemaps.

Conclusion

Sometimes, it is not necessary to have such a complex hierarchical organization to your data. If these situations occur, we come to your help with the solution described above. Also, it is easy to enable back the drill down feature. Just turn on the Visual header!

Is drill down useful for your projects? How did you disable it? Do let us know in the comments section below!

RELATED ARTICLES YOU NEED TO CHECK OUT:

idee restoro Still having issues? Fix them with this tool:
  1. Download this PC Repair Tool rated Great on TrustPilot.com (download starts on this page).
  2. Click Start Scan to find Windows issues that could be causing PC problems.
  3. Click Repair All to fix issues with Patented Technologies (Exclusive Discount for our readers).

Restoro has been downloaded by 0 readers this month.

This article covers:Topics: