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
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 »
WHAT IS AVAILABILITY SET & AVAILABILITY ZONE
Azure
Kaushlendra Mishra

What is Availability Set and Availability Zone in Azure?

What is Availability Set and Availability Zone in Azure? In Availability Set, VM`s copy is created and is isolated with separate physical servers, computer racks, storage units, network switches in a data center within a region so if one of the VM stops working then still we have the copy of the VM working within the same datacenter. While Availability Zone ensures that complete datacenter data is replicated to another place at a distance within the same region so that even if complete data center fails due to any reason then also Availability of data is ensured.

Read More »
prepare-DP-200-exam
Azure
Kaushlendra Mishra

How to Prepare for DP-200 Exam?

I have passed the DP-200 exam on 28 Oct 2020. I have gone through the various study material and courses in order to prepare for the exam. Overall, the time taken by me for the DP-200 exam is approx 3 months. Ideally, you should not take 3 months of time but due to lack of guidance, I happen to take a number of online courses which was not required to be taken for passing the DP-200 Exam.

Read More »

Leave a Comment

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