![up and down arrows chart up and down arrows chart](https://cdn-adclh.nitrocdn.com/zciqOWZgDznkuqFpvIJsLUeyHlJtlHxe/assets/static/optimized/rev-ae61699/wp-content/uploads/2014/05/Excel-Chart-with-Regular-Chart-Labels.png)
for example, when you are in days, you don’t know that what month these days belong too. There is a small problem in the selective drill down, and that is if you are in a lower level, you don’t know which higher level you are in. Make sure to turn it OFF when you have finished the data exploration. The selective drill-down is possible as long as you have the drill mode as ON. This can be used to find anomalies in the data and going and investigating that area more in detail. This ability to selectively drill down and drill up to areas you want is a fantastic data exploration technique. If we use the Drill Up button (the single arrow up) then we go one level up in the hierarchy drilling up in a visual in Power BI You are selectively drilling down to specific data sections. This action will traverse the levels of the hierarchy until the lowest level for as long as you click on a column. If you click on a quarter, then you will see the visual drills down to the months of that quarter If you click on a column, it will drill down to that section of the data, for example, If I click on 2007, then it will drill down to the quarters of that year. This means now that visual is in drill mode. Click on the single arrow down, which is also called drill mode. Now, let’s see what the selective drill down is.
![up and down arrows chart up and down arrows chart](https://i.pinimg.com/736x/03/98/71/03987152e4426d9babe77e107170d78e.jpg)
To understand the very first ability in the drill-down options, let’s see what is the default action when we click on a column in the column chart The default action is that the column gets highlighted highlighting a value in a Power BI visual Let’s see how these options work Selective drill down: Data Exploration This will lead to seeing drill down/up buttons on the top of the visual (or at the bottom of it if the visual is touched at the very top of the report) Drill down/up buttons in Power BI visuals This can be also done by having a date field which is using the built-in Power BI date hierarchy and table.įor example, in the visual below I have SalesAmount as the Value of the column chart, and the Date field (OrderDate) as the X-Axis. A hierarchy in a visual can be simply created by dragging and dropping multiple fields one after the other into the same field’s section of a visual. You will see the drill-down/and up options on a visual if you have a hierarchy of fields in that visual.