- 30
- 40 158
Power Bi Skills
India
เข้าร่วมเมื่อ 20 เม.ย. 2023
Through this channel, my endeavour is to upskill my viewers with latest cutting edge Business Intelligence tool of Microsoft Power Bi. I will share with my viewers lot of tips, tricks and best practices in power bi tool. I am sure that after going through these videos, users will enhance their knowledge and would be able to develop the professional level reports and Dashboards in power bi.
Amazing Button Slicer Feature (Introduced in November Power Bi Upgrade)
#PowerBI #DataAnalytics #BusinessIntelligence #timeintelligence
In this video I have explained how to use a new and awesome power bi functionality of Button Slicer which will make our Power bi reports more presentable. This feature is introduced by Microsoft in November month power bi Upgrade. I have also saved the example dataset link below for my viewers to practice this feature.
Enjoy this video and do subscribe for more such useful power bi tricks.
📣 Download Example Dataset from the link below:
docs.google.com/spreadsheets/d/1wC6z9DAJKfjizeDbo7b2hWZesffGw12m/edit?usp=sharing&ouid=102442369912535124190&rtpof=true&sd=true
🕓 TIMESTAMPS
0:00 Introduction
My Other useful Video links:
1. Power Bi DAX Basics.
th-cam.com/video/xcPflivor64/w-d-xo.html
2. How to create Hierarchy in Power bi
th-cam.com/video/fciyTVf1ILQ/w-d-xo.html
4. Awesome Trick of adding Measures to a Slicer in Power bi
th-cam.com/video/NAk99ZBCC_M/w-d-xo.html
3. Power bi customized and Dynamic Tooltip
th-cam.com/video/ROgQCRKrRQE/w-d-xo.html
4. KPI and Gauge Visual in Power Bi (part 1)
th-cam.com/video/_dXquIjef3s/w-d-xo.html
5. KPI and Gauge Visual in Power Bi (Part 2)
th-cam.com/video/oUEP3cN7FSo/w-d-xo.html
6. Swapping Visual trick in power bi
th-cam.com/video/mjU2pUfznMU/w-d-xo.html
7. Create Pro level Column chart in power bi in just 5 mins
th-cam.com/video/ianTJuRfrzg/w-d-xo.html
8. Trick to add Dynamic pop-up comments in power bi report.
th-cam.com/video/6Zi6p0aJeI4/w-d-xo.html
9. Basics of Power bi (for Beginners)
th-cam.com/video/OVG54NUQG9U/w-d-xo.html
10. Drill through feature in power bi
th-cam.com/video/qmleNoQ5SIk/w-d-xo.html
11. 3 most important Dax functions in power bi
th-cam.com/video/pDQVGSyhkTY/w-d-xo.html
12. Easiest way to create Fiscal date table in Power Bi with the help of Dax function.
th-cam.com/video/o2a7eyrHjVE/w-d-xo.html
13. Wonderful trick to do custom sort of data in Power Bi
th-cam.com/video/_zkuMvtiHn0/w-d-xo.html
📧 Connect with me
Email: rupani1975@gmail.com
Instagram: powerbiskills
🤝 About Power Bi Skills Channel
Through this channel, i am sharing tutorials to my viewers to become expert in Power Bi, Power Query and Power Automate. I have covered in details various tips and tricks in power bi ( Customized Tooltip, Dax Functions, Visual Swapping trick, Customized Hierarchy and adding Dynamic POP-UP comments in power bi) which most of the viewers would not be familiar with. Objective of this channel is to share my Power bi knowledge with others so that they would get benefit out of it in their professional life.
#PowerBI #DataAnalytics #BusinessIntelligence #timeintelligence
In this video I have explained how to use a new and awesome power bi functionality of Button Slicer which will make our Power bi reports more presentable. This feature is introduced by Microsoft in November month power bi Upgrade. I have also saved the example dataset link below for my viewers to practice this feature.
Enjoy this video and do subscribe for more such useful power bi tricks.
📣 Download Example Dataset from the link below:
docs.google.com/spreadsheets/d/1wC6z9DAJKfjizeDbo7b2hWZesffGw12m/edit?usp=sharing&ouid=102442369912535124190&rtpof=true&sd=true
🕓 TIMESTAMPS
0:00 Introduction
My Other useful Video links:
1. Power Bi DAX Basics.
th-cam.com/video/xcPflivor64/w-d-xo.html
2. How to create Hierarchy in Power bi
th-cam.com/video/fciyTVf1ILQ/w-d-xo.html
4. Awesome Trick of adding Measures to a Slicer in Power bi
th-cam.com/video/NAk99ZBCC_M/w-d-xo.html
3. Power bi customized and Dynamic Tooltip
th-cam.com/video/ROgQCRKrRQE/w-d-xo.html
4. KPI and Gauge Visual in Power Bi (part 1)
th-cam.com/video/_dXquIjef3s/w-d-xo.html
5. KPI and Gauge Visual in Power Bi (Part 2)
th-cam.com/video/oUEP3cN7FSo/w-d-xo.html
6. Swapping Visual trick in power bi
th-cam.com/video/mjU2pUfznMU/w-d-xo.html
7. Create Pro level Column chart in power bi in just 5 mins
th-cam.com/video/ianTJuRfrzg/w-d-xo.html
8. Trick to add Dynamic pop-up comments in power bi report.
th-cam.com/video/6Zi6p0aJeI4/w-d-xo.html
9. Basics of Power bi (for Beginners)
th-cam.com/video/OVG54NUQG9U/w-d-xo.html
10. Drill through feature in power bi
th-cam.com/video/qmleNoQ5SIk/w-d-xo.html
11. 3 most important Dax functions in power bi
th-cam.com/video/pDQVGSyhkTY/w-d-xo.html
12. Easiest way to create Fiscal date table in Power Bi with the help of Dax function.
th-cam.com/video/o2a7eyrHjVE/w-d-xo.html
13. Wonderful trick to do custom sort of data in Power Bi
th-cam.com/video/_zkuMvtiHn0/w-d-xo.html
📧 Connect with me
Email: rupani1975@gmail.com
Instagram: powerbiskills
🤝 About Power Bi Skills Channel
Through this channel, i am sharing tutorials to my viewers to become expert in Power Bi, Power Query and Power Automate. I have covered in details various tips and tricks in power bi ( Customized Tooltip, Dax Functions, Visual Swapping trick, Customized Hierarchy and adding Dynamic POP-UP comments in power bi) which most of the viewers would not be familiar with. Objective of this channel is to share my Power bi knowledge with others so that they would get benefit out of it in their professional life.
#PowerBI #DataAnalytics #BusinessIntelligence #timeintelligence
มุมมอง: 151
วีดีโอ
Useful Trick to Transform Basic Bar Visual to Advanced level Bar visual in Power Bi.
มุมมอง 88411 หลายเดือนก่อน
#PowerBI #DataAnalytics #BusinessIntelligence #timeintelligence In this video, I have explained how we can convert a basic level Bar visual to more presentable and advanced Bar visual with few simple steps. Enjoy this video and do subscribe for more such useful power bi tricks. 📣 Download Example Dataset from the link below: docs.google.com/spreadsheets/d/1qN4jd_PC2HUWzj19icnSz-xqEJVPMGEu/edit?...
Awesome TopN feature in power bi with the help of RankX Dax function
มุมมอง 225ปีที่แล้ว
#PowerBI #DataAnalytics #BusinessIntelligence #timeintelligence In this Video I have explained in detail a very useful feature of TopN filter and Ranking with the help of RankX Dax function in various practical scenarios. Enjoy this video and do subscribe for more such useful power bi tricks. 📣 Download Example Dataset from the link below: docs.google.com/spreadsheets/d/1hRDyJ9hPA-5bOLYq7rRfm97...
Awesome trick to display Last N months trend in your Power Bi Visual {Not many people know}
มุมมอง 883ปีที่แล้ว
#PowerBI #DataAnalytics #BusinessIntelligence #timeintelligence In this video, I have explained a very useful trick of displaying fixed number of prior month's trend analysis through power bi visuals. I have also explained the dynamic Number of months selection through slider and how we can see the trend analysis with multiple parameters. Enjoy this video and do subscribe for more such useful p...
Awesome Page Navigation Feature in Power Bi
มุมมอง 2.5Kปีที่แล้ว
#PowerBI #DataAnalytics #BusinessIntelligence #timeintelligence In this video, i have explained the page navigation feature in power bi. Instead of having report with multiple tabs, we can have customised page navigation buttons appearing on the report itself which allows the users to navigate through various pages of the report by just clicking the buttons appearing on the report itself. Enjoy...
How to create the New Card Visual in Power Bi? Far more advanced than the old Card Visual.
มุมมอง 624ปีที่แล้ว
#PowerBI #DataAnalytics #BusinessIntelligence #timeintelligence In this Video, i have explained how to create New card visual in power bi. This is an amazing visual introduced in June 2023. This is far better than old card visual. Enjoy this video and do subscribe for more such useful power bi tricks. 📣 Download Example Dataset from the link below: docs.google.com/spreadsheets/d/14dYwwfIbak_xRq...
Create Gantt chart visual with the help of basic Matrix visual in Power Bi
มุมมอง 1.9Kปีที่แล้ว
#PowerBI #DataAnalytics #BusinessIntelligence #timeintelligence In this Video, I have explained how to convert a basic matrix chart visual to a professional level Gantt Chart visual which is very useful from project management perspective. Enjoy this video and do subscribe for more such useful power bi tricks. 📣 Download Example Dataset from the link below: docs.google.com/spreadsheets/d/1FFQQu...
Amazing trick to transform basic line chart to advanced control chart and KPI chart in Power Bi
มุมมอง 1.2Kปีที่แล้ว
#PowerBI #DataAnalytics #BusinessIntelligence #timeintelligence In this video, i have explained my viewers how to convert a basic level line chart visual to an advanced level control chart / KPI chart visual in power bi. This is very helpful while doing variance analysis and measuring the consistency in performance. Enjoy this video and please don't forget to like and subscribe my channel :). 📣...
Trick to create customised and dynamic data labels in power bi visuals with Dax functions
มุมมอง 547ปีที่แล้ว
#PowerBI #DataAnalytics #BusinessIntelligence #timeintelligence In this video, i have explained a useful trick to create customised and dynamic data labels in our power bi visuals with the help of DAX functions. This video is in continuation of my previous video where i had explained the trick of dynamic colour and chart title. I have used the same example dataset which i had used in my previou...
Amazing trick of applying dynamic colors and title in power bi visuals with the help of DAX function
มุมมอง 668ปีที่แล้ว
#PowerBI #DataAnalytics #BusinessIntelligence #timeintelligence In this video, i have explained an awesome trick in power bi to add dynamic colors and title in your power bi visuals with the help of DAX functions. I have also saved the example dataset, used in this video, for my viewers to download and practice this trick on your own. Enjoy this video and please don't forget to like and subscri...
Dynamic Waterfall visual in Power Bi
มุมมอง 1.2Kปีที่แล้ว
#PowerBI #DataAnalytics #BusinessIntelligence #timeintelligence In this Video, i have explained how to create a very useful Dynamic Waterfall visual in power bi with the help of measures and field parameter option. I have also explained what is Waterfall Visual and in which scenario we can use this visual. Enjoy this Video and subscribe to my channel. 📣 Download Example Dataset from the link be...
Time Intelligence based DAX functions in Power Bi
มุมมอง 2.6Kปีที่แล้ว
#PowerBI #DataAnalytics #BusinessIntelligence #TimeIntelligence In this video, i have explained my viewers the most important concept of Time Intelligence in Power Bi. I have also covered 13 most frequently used Time Intelligence based DAX functions in Power Bi. These will be very helpful while doing comparative analysis of data with prior period data or calculating the cumulative values basis ...
Useful feature of change settings in Power Bi to make slicer interact with selective visuals !!
มุมมอง 119ปีที่แล้ว
In this video, i have explained the Edit Interaction feature in power bi which enables us to limit the interaction of slicer with particular visual or visuals. My Other useful Video links: 1. Power Bi DAX Basics. th-cam.com/video/xcPflivor64/w-d-xo.html 2. How to create Hierarchy in Power bi th-cam.com/video/fciyTVf1ILQ/w-d-xo.html 4. Awesome Trick of adding Measures to a Slicer in Power bi th-...
Easiest way to create Fiscal date table in Power Bi with the help of Dax function.
มุมมอง 509ปีที่แล้ว
#PowerBI #DataAnalytics #BusinessIntelligence In this video, I have explained how we can create a calendar date table and fiscal year date table in power bi with the help of simple Dax functions. Enjoy this video and please subscribe in case you find it useful. Time stamp : 0:00 Introduction 1:05 Creation of Calendar date table 8:50 Creation of Fiscal date table My Other useful Video links: 1. ...
Wonderful trick to do custom sort of data in Power Bi
มุมมอง 285ปีที่แล้ว
In this video, i have explained my viewers how to do custom sort of data (other than standard ascending or descending order) in the power bi visuals. I have also saved the link of the example file below for my viewers to practice this functionality. Enjoy this video and do subscribe for more such useful power bi tricks. Time Stamp : 0:00 Introduction of the topic 1:38 explanation of Example Dat...
Awesome Trick to transform your Bar Chart to Gantt Chart Visual in Power BI(Project Management tool)
มุมมอง 710ปีที่แล้ว
Awesome Trick to transform your Bar Chart to Gantt Chart Visual in Power BI(Project Management tool)
How to perform SUMIF ; COUNTIF and AVERAGEIF in Power Bi with the help of DAX Functions ??
มุมมอง 446ปีที่แล้ว
How to perform SUMIF ; COUNTIF and AVERAGEIF in Power Bi with the help of DAX Functions ??
Amazing Tips to transform your Power Bi Report to PRO LEVEL Report in 3 easy steps.
มุมมอง 290ปีที่แล้ว
Amazing Tips to transform your Power Bi Report to PRO LEVEL Report in 3 easy steps.
Awesome trick of Adding Measures to a slicer in power bi.
มุมมอง 7Kปีที่แล้ว
Awesome trick of Adding Measures to a slicer in power bi.
Important Dax Functions in Power Bi (All ( ) ; AllEXCEPT ( ) ; AllSELECTED ( )
มุมมอง 1.1Kปีที่แล้ว
Important Dax Functions in Power Bi (All ( ) ; AllEXCEPT ( ) ; AllSELECTED ( )
Drill Through Functionality in Power Bi (Amazing Feature)
มุมมอง 2.6Kปีที่แล้ว
Drill Through Functionality in Power Bi (Amazing Feature)
Power Bi Tutorials for Beginners (Basics of Power bi)
มุมมอง 1.3Kปีที่แล้ว
Power Bi Tutorials for Beginners (Basics of Power bi)
Trick to add dynamic Pop up Comments in Power Bi reports [not many people know]
มุมมอง 2.7Kปีที่แล้ว
Trick to add dynamic Pop up Comments in Power Bi reports [not many people know]
Create Pro Level Column chart Visual in Power Bi in just 5 minutes
มุมมอง 887ปีที่แล้ว
Create Pro Level Column chart Visual in Power Bi in just 5 minutes
KPI and Gauge Visuals in Power BI (part 2)
มุมมอง 349ปีที่แล้ว
KPI and Gauge Visuals in Power BI (part 2)
KPI & Gauge Visuals in Power BI (Part 1)
มุมมอง 725ปีที่แล้ว
KPI & Gauge Visuals in Power BI (Part 1)
Most Frequently used Dax Functions in Power Bi
มุมมอง 6Kปีที่แล้ว
Most Frequently used Dax Functions in Power Bi
Power Bi Skills. Customised and Dynamic Tooltip
มุมมอง 712ปีที่แล้ว
Power Bi Skills. Customised and Dynamic Tooltip
Finished practicing
No funciona
You are amazing sir. I am learning a lot from your videos. Very clear explanation kindly upload more videos like this. This Thursday I have an interview. If I get through I'll come and comment again. Thanks a lot sir. 😊
Thanks so much !! All the best for your interview 👍
Will this work for excel power query as well?
Excellent! it was exactly what I was looking for! great work, thanks!
Very good video that i learnt
Please provide dataset for practice
Finished watching
Finished practicing
Great idea, thanks!
Finished watching
Brilliant video
Hello sir same I was create three tab but tab not navigate so which version you used
Sir. Thank you very much for your tutorial. It helped me so much. Much appreciated...great channel. 👌👌🏆🏆💯💯
Hi I am trying to follow the same steps and Crete Gantt chart at quarterly level but the formula is not working
page navigation not working, what should i do ?
Same here have you got solution
did you try pressing the button while pressing ctrl key?
Thank you..Really very helpfull
In my dashboard navigation button not activated, what should i do
Thanks for your message. Pls send me your query over email with print screen where you are facing problem. I’ll revert back ASAP. My email id is rupani1975@gmail.com
it's good. but can we have conditional colours for bars..
Thanks for your message. Yes, that’s simple. You’ll have to create a measure with Dax function to do condition colouring of bars. Once measure is created then go to format and select bars option. Along with default colour, there is a button “fx”. Click on that and select your measure from field values to enable conditional bar colours. Let me if you still face any challenges.
How to bring ytd growth %
Hi Do have vedio for mtd qtd and ytd If yes please provide link
Thank this has requested info
Dear Mohan… pls refer to my video on Time Intelligence. I have covered MTD and QTD in that video. In case you still have any doubts or questions then you can reach out to me.
I gone through multiple vedios for fiscal year for Indian fiscal year but not have clarity Now understand what I want to make April to March using - 3 If any I will text you for support
Explained very well thanks for explanation Just I am looking Fiscal year like as FY24 CAN I GET THE CODE FOR THE SAME
Kindly share the Data set sir
Please I need days ?
This is very simple. In Sales Trend measure, in "Datesinperiod" Dax function, mention number of days in minus instead of months and specify interval as "Day" instead of "month".
@@PowerBiSkills- please sample
Great tip, thank you!
Thank you for sharing your skills
ThaNK YOU, THIS REALLY HELPED A LOT.
Thanks so much for appreciating my work !!!
sir I'm from Sri Lanka. The way you teach is amazing. please keep this simplicity in your future videos as well. I have tried many times to learn dax through youtube tutorials but ended up being failed due to the complexity of the examples that tutorial provider use to explain dax, but after watching your videos I felt that your method of teaching is very unique and easy to understand because you use simple examples rather using complex multi tables and you always talk to the point. Thank you very much.😍
Thanks for supporting my work. This motivates me to perform better. 🙏
Excellent teaching 👌👌👌👌
Thanks !!
ah this is the same "teacher" that uses lookup value in power BI to create new columns instead of using a relationship model. You should explain why you are doing it this way, cause for a nobody like me it makes no sense.
Did i see someone use a lookup to create new columns instead of using the relationship model?
Hi Sir, If you make video on Manage Relationship in power bi it will be more useful for us. Thanks This is video also more helpful for us.
Thanks Rahul !! I will make this video.
Sir please make video on future N month trend in power bi
In this video, I have explained Total sales trend analysis measure. In that measure, if you write month interval of +4 instead of -4 which I had mentioned then you’ll get the sales numbers for next 4 month starting from month selected in the slicer. You can try this solution.
Hi sir I want the parameter like quarter , monthly,daily and also month year should be there in the slicer so if we select quarter in the parameter some graphs has to show quarter wise data if change the monthly it has to show monthwise data without affecting the monthyear slicer we add and some graphs has to show the particular month value is it possible
Thanks Chaitanya !! What you are asking can be easily achieved through hierarchy of day, month, quarter and year and put it on a slicer. If you select quarter then you’ll get quarterly trend and similarly if you select month the you will get monthly trend. There is no need to create any measure for this.
Very useful
Hi sir it is very useful thankyou for the video sir I have one doubt we have to give one parameter or filter like monthly and quarterly and daily so when we click on quarterly it has to show quarter wise value if we select monthly we have to get monthwise data and when we select daily it has to show the date wise value
It is very useful thank you for the video I have one doubt like can we get single date instead multiple dates in powerbi means if we give two dates as a parameter or filter so that if we select one date the data has to be change according to that date and vice versa is it possible ? in tableau it is possible
Thanks you sir for teaching
It's my pleasure
its work for single selection can you show it for multiple selection
Sure !! Multiple selection can be possible with Data modelling Field parameters functionality.
Nice video ❤
Thanks !!
thanks great
I like how you teach.
Thanks so much!!
Hi, Thanks for this wonderful tutorial. Can you create gantt chart with SVG in matrix?
Thank you for awesome contents.
Thanks !!
Amazing video and briefly explained. Thank you sir making these learnings available for us 🙂
That works for 1 year. What if you have to do with multiple years
Thanks for your comment. This would work with multiple years as well. You should give the date range which could be multiple years of date range (for example 1-jan- 2020 till 30-Sep-2023). Pls. try and let me know in case you still face any challenge.
Don't mind what other people says. Keep up with the good work. Some organizations mind find it usefull or not. Who knows? But its always welcoming and good to know
Thanks so much !!
Thank you so much sir. New version features are not available. But you put the new version feature. Thank you
Hello sir