Drill-through is an option in power bi desktop using which we can drill through to a page having details with a specific context. After the March 2020 update, Drill through can be performed using the button as well, earlier the same task was performed by right-clicking on a context in a chart and then selecting the drill through option.




So in this article, let`s see How to perform drill-through action using a button in Power BI? 


Step 1: For the demo, we will be using the Sample superstore dataset which you can download from here.

I would suggest you follow along with me if you are not aware of performing drill though action using button functionality in Power BI. Once you do it of your own then you learn the most out of anything and it`s better than just reading and later forgetting. That`s why I try to create Do it yourself kind of article.

Step2: On Page 1, Create a pie chart showing sales by region.



Step 3: On-Page 1,  Also, Create a button and use conditional formatting in the button text.



  • We will be showing "See Region Details" when nothing is selected in the Pie Chart 









  •  When any of the legends is selected, for example, we have selected east in the pie chart then button text will change to "See Details for East".



We have used Dax expression here for conditional formatting of the button text. You can find the DAX expression below



see details =
IF (
    SELECTEDVALUE ( Orders[Region] ) = "",
    "See Region Details",
    "See Details for " & SELECTEDVALUE ( Orders[Region] )
)


You have to select the button and go to the visualization pane. In the Button Text property, click the fx button.


Once you click the fx button. you will be asked to enter the measure so that conditional formatting can be performed.



Step 4: Let`s Now create Page 2 which has various charts that will get filtered on the basis of Region selected in the piechart in Page1. So it's important that in the data model fields used in the chart in Page 2 must have a relation with Region field used in the PieChart in Page 1. 

See the image below and create the visuals.



Step5: On Page 2, Add the Region field in the Drill through filter option in the visualization pane.





Step6: On Page 1: Select the button and go to visualization pane action property. Their select the type as Drill through and destination as Page 2.



Final Thoughts

 

Microsoft Power BI updates have been providing a lot of new features that can help us to achieve a lot of functionality which was not possible earlier. Drill-through is an important feature in Power BI as it helps us to see the details with a specific context. Using it with the button will certainly add more interactivity to the report. So practice it on your machine and keep learning.

I hope that you would have find the article interesting and must have added value to your learning. Please provide me feedback on the comment section.


How to perform drillthrough action using button in Power BI?



Drill-through is an option in power bi desktop using which we can drill through to a page having details with a specific context. After the March 2020 update, Drill through can be performed using the button as well, earlier the same task was performed by right-clicking on a context in a chart and then selecting the drill through option.




So in this article, let`s see How to perform drill-through action using a button in Power BI? 


Step 1: For the demo, we will be using the Sample superstore dataset which you can download from here.

I would suggest you follow along with me if you are not aware of performing drill though action using button functionality in Power BI. Once you do it of your own then you learn the most out of anything and it`s better than just reading and later forgetting. That`s why I try to create Do it yourself kind of article.

Step2: On Page 1, Create a pie chart showing sales by region.



Step 3: On-Page 1,  Also, Create a button and use conditional formatting in the button text.



  • We will be showing "See Region Details" when nothing is selected in the Pie Chart 









  •  When any of the legends is selected, for example, we have selected east in the pie chart then button text will change to "See Details for East".



We have used Dax expression here for conditional formatting of the button text. You can find the DAX expression below



see details =
IF (
    SELECTEDVALUE ( Orders[Region] ) = "",
    "See Region Details",
    "See Details for " & SELECTEDVALUE ( Orders[Region] )
)


You have to select the button and go to the visualization pane. In the Button Text property, click the fx button.


Once you click the fx button. you will be asked to enter the measure so that conditional formatting can be performed.



Step 4: Let`s Now create Page 2 which has various charts that will get filtered on the basis of Region selected in the piechart in Page1. So it's important that in the data model fields used in the chart in Page 2 must have a relation with Region field used in the PieChart in Page 1. 

See the image below and create the visuals.



Step5: On Page 2, Add the Region field in the Drill through filter option in the visualization pane.





Step6: On Page 1: Select the button and go to visualization pane action property. Their select the type as Drill through and destination as Page 2.



Final Thoughts

 

Microsoft Power BI updates have been providing a lot of new features that can help us to achieve a lot of functionality which was not possible earlier. Drill-through is an important feature in Power BI as it helps us to see the details with a specific context. Using it with the button will certainly add more interactivity to the report. So practice it on your machine and keep learning.

I hope that you would have find the article interesting and must have added value to your learning. Please provide me feedback on the comment section.


No comments