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
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.
@@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
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..
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?
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.
Love you PK ji you are my Dronacharya!
Thanks for your valuable feedback
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
Thanks PK, It was very useful.
Most welcome🙏
Valuable Content.. Thanks
Most welcome🙏
It's very helpful to me Thank you so much for uploading this video🫠
My pleasure 😊
Thanks for explaining very clearly..
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
Thanks man,
So helpful
Most welcome
Thank you.
Most welcome
Full of clarity sir ji keep upload more videos
Thanks for your valuable feedback
Million Thanks
Most welcome
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.
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
thanks pk it was very useful
can you help me. how can compare quarterly data
Will upload soon
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.
Hi, thanks. Can we use button for waterfall chart
Very good session
Thanks for your valuable feedback
Very informative and helpful!
Great video sir ji👍
Thanks for your valuable feedback
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..
sir ,yeh conversion rate konse measure aya starting ki visual main
Can Tackometer have drill down or drill through?
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?
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.
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
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