3 Ways to use the Drill Through in Power BI
Vložit
- čas přidán 26. 05. 2021
- #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-anexcelexpert.com/3-wa...
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-anexcelexpert.com/exce...
Download the Calendar Control in VBA from below link
www.pk-anexcelexpert.com/full...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
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-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Pinterest:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/shop/pkanexcele...
Thank you.
Most welcome
Very informative and helpful!
Valuable Content.. Thanks
Most welcome🙏
Thanks man,
So helpful
Most welcome
Thanks for explaining very clearly..
Thanks for your valuable feedback
Thanks PK, It was very useful.
Most welcome🙏
Love you PK ji you are my Dronacharya!
Thanks for your valuable feedback
Power Bi has updated the buttons we can add now to include Page & Bookmark Navigator options...makes things so simple
Million Thanks
Most welcome
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
Full of clarity sir ji keep upload more videos
Thanks for your valuable feedback
Excellent Video. Thank You
Thanks for your valuable feedback
@@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
Awesome as usual!
Thanks for your valuable feedback
@@PKAnExcelExpert I replicated the report. The only change I made was adding a reset filter button on the Employee Details page.
Very good session
Thanks for your valuable feedback
It's very helpful to me Thank you so much for uploading this video🫠
My pleasure 😊
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.
Great video sir ji👍
Thanks for your valuable feedback
Hi, thanks. Can we use button for waterfall chart
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.
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?
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..
Can Tackometer have drill down or drill through?
sir ,yeh conversion rate konse measure aya starting ki visual main
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.
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.
*18:45
How it will work on power bi service?
In the initial part of the I used Power BI services. You can simply publish it to the Power BI services.
Any one can help me with measure
Hi PK, please send data
too round about... no proper flow.... First start with What is drill through and why we need it and then demo...Need