3 Ways to use the Drill Through in Power BI

#PowerBI #DrillThrough
Hello Friends,

In this video, you will learn 3 different ways to Drill Through in Power BI. Drill through is used to navigate different pages within the report with the filter of selected data point like Supervisor, supplier, customer, or manufacturer.

#1: Right Click on the data point
#2: Use Button to Drill through
#3: Use Modern Tooltip

Download the practice file from below link:

Quality Dashboard in Power BI:

Learn and download our interactive Excel dashboards free of cost-

Download the Free Project Management Dashboard

Download the Calendar Control in VBA from below link

Download our free Excel utility Tool and improve your productivity:

See our Excel Products:

Visit to learn more:

Watch the best info-graphics and dynamic charts from below link:

Learn and free download best excel Dashboard template:

Learn Step by Step VBA:

Website:

Facebook:

Telegram:

Pinterest:

Visit our Amazon Store

[sharmacoke]

Love you PK ji you are my Dronacharya!

[supafly]

Power Bi has updated the buttons we can add now to include Page & Bookmark Navigator options...makes things so simple

[banasaikrishna]

Thanks for doing it easily understandable to everyone.
I have a query,
You explained drill through(with button) and without button for navigating and filtering the data based on selection.
Then How to drill through and filter based on selection just by clicking on bar in bar visual
Note: Just by clicking bar in bar visual it has to naviagate to another page with selected bar betails

[sarsatheeshreddy]

Full of clarity sir ji keep upload more videos

[sonaligade]

It's very helpful to me Thank you so much for uploading this video🫠

[priyaranjanmh]

Hello, thank you for the wonderful session. I have one question, while multi select the bar in chart the drill through button not coloring, what supposed to get this enabled.

[SanviPatil]

Bahot badhiya video sir..
Sir VBA ME SALARY REGISTER ME SHEET2 ME ALL EMPLOYEE KI PAY SLIP AUTO GENRATE KARKE KISIBHI LOCATION ME SAVE KAISE KARE.. AUR USI SHEET2 ME SE HUM AUTO EMAIL KAISE SEND KARE ALL EMPLOYEE KO.. MAKE VIDEO SIR..

[khaleeldubai]

Hi, thanks. Can we use button for waterfall chart

[fizaali]

sir, yeh conversion rate konse measure aya starting ki visual main

[shaileshsingh]

Hi PK, I have a question for you, I have an HR data by which I have created 3 matrix in power Bi, 1 for New employee, 2 for total number of employee
3 for attrition, all three matrix have departments in rows and months in columns.
Now for 2 matrix I have taken running total that add last month value and newly recruited employee in present month using calculate function, this works fine but when I tried to subtract attrition values from above running total it start giving wrong result,
Ex :-If there is 1 attrition in any department in current month then my formula start subtracting 1 from each department and hence produce wrong result.

please help in writing correct Dax function. Please help with this measure.

[wasifangel]

I have few desktops related to my excel files. After few months, power bi files do not show the data. My excel files remained in the same destination folder. Is there any solution, so that i have permanent desktop in power bi for my excel files?

[nandhuse]

Can Tackometer have drill down or drill through?

[sridharkrishnappanavanerth]

Sir, I have problem in pivot table, Please help me out.
i am working on inventory project in my company. My boss is asking me to show 1) maximum sales for any particular day of the week for any month and any particular year. 2) closing balance for end of month for any particular month and year. can you demonstrate this with a video how to achieve this, thanks in advance.

[prabodhkurmi]

Dear expert, pls help me to calculate time difference multiplied with number to get in numbers. example
Prod Start Time 01/06/2021 06:00
Prod End Time 02/06/2021 18.45
difference will be in hr:mm will be multiplied with 600 (capacity/hr) to get the result in numbers. This required to calculate the efficiency of production line.

[georgedong]

too round about... no proper flow.... First start with What is drill through and why we need it and then demo...Need