How to perform drillthrough action using button in Power BI?

Table of Contents

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 through 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 the Region selected in the piechart on Page1. So it’s important that the data model fields used in the chart on Page 2 must have a relation with the Region field used in the PieChart on 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 to find the article interesting and must have added value to your learning. Please provide me feedback on the comment section.

Categories
QUICK REPORT IN POWER BI SERVICE
Power BI Desktop
Kaushlendra Mishra

How to create a report quickly in Power BI Service?

Do you want to create a quick report in Power BI? The latest Power BI version has made it possible to create a quick report using data from the web and existing published datasets in Power BI Service. So, now you do need to download the Power BI Desktop software into your PC and directly make a report using the Power BI service.

Read More »

Leave a Comment

Your email address will not be published. Required fields are marked *