3 Ways to use the Drill Through in Power BI

No video

3 Ways to use the Drill Through in Power BI

Рет қаралды 81,176

Күн бұрын

#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:
www.pk-anexcel...
Quality Dashboard in Power BI:
• Quality Analysis Dashb...
Learn and download our interactive Excel dashboards free of cost-
• Excel Dashboards
Download the Free Project Management Dashboard
www.pk-anexcel...
Download the Calendar Control in VBA from below link
www.pk-anexcel...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcel...
See our Excel Products:
www.pk-anexcel...
Visit to learn more:
Chart and Visualizations: www.pk-anexcel...
VBA Course: www.pk-anexcel...
Download useful Templates: www.pk-anexcel...
Dashboards: www.pk-anexcel...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
WWW.PK-AnExcel...
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/...
Pinterest:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/...

Пікірлер: 46

@carlocalingasan998 29 күн бұрын

Thank you.

@PKAnExcelExpert 29 күн бұрын

Most welcome

@supafly8 8 ай бұрын

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

@sharmacoke007 3 жыл бұрын

Love you PK ji you are my Dronacharya!

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@muhammadx656 Жыл бұрын

Valuable Content.. Thanks

@PKAnExcelExpert Жыл бұрын

Most welcome🙏

@kareemdamilola-pv3np 3 ай бұрын

Thanks man, So helpful

@PKAnExcelExpert 3 ай бұрын

Most welcome

@nehashahpatel1741 2 жыл бұрын

Million Thanks

@PKAnExcelExpert 2 жыл бұрын

Most welcome

@rdj4u 3 жыл бұрын

Thanks for explaining very clearly..

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@syednawaz819 9 ай бұрын

Thanks PK, It was very useful.

@PKAnExcelExpert 9 ай бұрын

Most welcome🙏

@sarsatheeshreddy3341 3 жыл бұрын

Full of clarity sir ji keep upload more videos

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@sonaligade3177 6 ай бұрын

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

@PKAnExcelExpert 6 ай бұрын

My pleasure 😊

@banasaikrishna420 Жыл бұрын

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

@garyallan69 3 жыл бұрын

Excellent Video. Thank You

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@garyallan69 3 жыл бұрын

@@PKAnExcelExpert Your welcome. What I loved about it that it was direct and straight to the point showing each step without a lot of any unnecessary talk about other irrelevant topics

@rochellerobinson939 3 жыл бұрын

Awesome as usual!

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@rochellerobinson939 3 жыл бұрын

@@PKAnExcelExpert I replicated the report. The only change I made was adding a reset filter button on the Employee Details page.

@yallamandab7976 3 жыл бұрын

Very good session

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@airfryerhomecooked1778 3 жыл бұрын

Very informative and helpful!

@Explorewith_RJ 3 жыл бұрын

Great video sir ji👍

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@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.

@fizaali3736 4 ай бұрын

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

@khaleel26dubai Жыл бұрын

Hi, thanks. Can we use button for waterfall chart

@SanviPatil2019 3 жыл бұрын

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..

@wasifangel 3 жыл бұрын

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?

@shaileshsingh8906 3 жыл бұрын

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.

@nandhuse 3 жыл бұрын

Can Tackometer have drill down or drill through?

@msdsulthan4243 3 жыл бұрын

How it will work on power bi service?

@PKAnExcelExpert 3 жыл бұрын

In the initial part of the I used Power BI services. You can simply publish it to the Power BI services.

@sridharkrishnappanavanerth3388 3 жыл бұрын

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.

@prabodhkurmi72 3 жыл бұрын

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.

@prabodhkurmi72 3 жыл бұрын

*18:45

@shaileshsingh8906 3 жыл бұрын

Any one can help me with measure