Power Bi Skills
Power Bi Skills
  • 30
  • 40 158
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
มุมมอง: 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)
Switching visuals in power bi
มุมมอง 604ปีที่แล้ว
Switching visuals in power bi
Most Frequently used Dax Functions in Power Bi
มุมมอง 6Kปีที่แล้ว
Most Frequently used Dax Functions in Power Bi
How to create Hierarchy in Power Bi
มุมมอง 1Kปีที่แล้ว
How to create Hierarchy in Power Bi
Power Bi Skills. Customised and Dynamic Tooltip
มุมมอง 712ปีที่แล้ว
Power Bi Skills. Customised and Dynamic Tooltip

ความคิดเห็น

  • @SandipanSarkar-c8v
    @SandipanSarkar-c8v 8 วันที่ผ่านมา

    Finished practicing

  •  หลายเดือนก่อน

    No funciona

  • @bhanupriya7507
    @bhanupriya7507 หลายเดือนก่อน

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

    • @PowerBiSkills-
      @PowerBiSkills- หลายเดือนก่อน

      Thanks so much !! All the best for your interview 👍

  • @ajayrathod7777
    @ajayrathod7777 2 หลายเดือนก่อน

    Will this work for excel power query as well?

  • @yymmrr16
    @yymmrr16 2 หลายเดือนก่อน

    Excellent! it was exactly what I was looking for! great work, thanks!

  • @saifulislam-xq9wh
    @saifulislam-xq9wh 3 หลายเดือนก่อน

    Very good video that i learnt

  • @SandipanSarkar-c8v
    @SandipanSarkar-c8v 4 หลายเดือนก่อน

    Please provide dataset for practice

  • @SandipanSarkar-c8v
    @SandipanSarkar-c8v 4 หลายเดือนก่อน

    Finished watching

  • @SandipanSarkar-c8v
    @SandipanSarkar-c8v 4 หลายเดือนก่อน

    Finished practicing

  • @manuelaherrerab6849
    @manuelaherrerab6849 4 หลายเดือนก่อน

    Great idea, thanks!

  • @SandipanSarkar-c8v
    @SandipanSarkar-c8v 4 หลายเดือนก่อน

    Finished watching

  • @estherewiogbe4832
    @estherewiogbe4832 4 หลายเดือนก่อน

    Brilliant video

  • @Raushankumar-di1lk
    @Raushankumar-di1lk 5 หลายเดือนก่อน

    Hello sir same I was create three tab but tab not navigate so which version you used

  • @oukiebotha2227
    @oukiebotha2227 6 หลายเดือนก่อน

    Sir. Thank you very much for your tutorial. It helped me so much. Much appreciated...great channel. 👌👌🏆🏆💯💯

  • @navneetkaursandhu3383
    @navneetkaursandhu3383 6 หลายเดือนก่อน

    Hi I am trying to follow the same steps and Crete Gantt chart at quarterly level but the formula is not working

  • @sta2591
    @sta2591 10 หลายเดือนก่อน

    page navigation not working, what should i do ?

    • @prakashwani7002
      @prakashwani7002 9 หลายเดือนก่อน

      Same here have you got solution

    • @abhishektiwari1861
      @abhishektiwari1861 8 หลายเดือนก่อน

      did you try pressing the button while pressing ctrl key?

  • @saileshkumarpradhan3700
    @saileshkumarpradhan3700 11 หลายเดือนก่อน

    Thank you..Really very helpfull

  • @Coding_with_Bharti
    @Coding_with_Bharti 11 หลายเดือนก่อน

    In my dashboard navigation button not activated, what should i do

    • @PowerBiSkills-
      @PowerBiSkills- 11 หลายเดือนก่อน

      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

  • @PrideEnchantaVagale
    @PrideEnchantaVagale 11 หลายเดือนก่อน

    it's good. but can we have conditional colours for bars..

    • @PowerBiSkills-
      @PowerBiSkills- 11 หลายเดือนก่อน

      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.

  • @nitishsingh4383
    @nitishsingh4383 11 หลายเดือนก่อน

    How to bring ytd growth %

  • @MohanMohan-zg9mr
    @MohanMohan-zg9mr 11 หลายเดือนก่อน

    Hi Do have vedio for mtd qtd and ytd If yes please provide link

    • @MohanMohan-zg9mr
      @MohanMohan-zg9mr 11 หลายเดือนก่อน

      Thank this has requested info

    • @PowerBiSkills-
      @PowerBiSkills- 11 หลายเดือนก่อน

      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.

  • @MohanMohan-zg9mr
    @MohanMohan-zg9mr 11 หลายเดือนก่อน

    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

  • @MohanMohan-zg9mr
    @MohanMohan-zg9mr 11 หลายเดือนก่อน

    Explained very well thanks for explanation Just I am looking Fiscal year like as FY24 CAN I GET THE CODE FOR THE SAME

  • @viswac2302
    @viswac2302 11 หลายเดือนก่อน

    Kindly share the Data set sir

  • @mostafabahnasi5512
    @mostafabahnasi5512 11 หลายเดือนก่อน

    Please I need days ?

    • @PowerBiSkills-
      @PowerBiSkills- 11 หลายเดือนก่อน

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

    • @mostafabahnasi5512
      @mostafabahnasi5512 11 หลายเดือนก่อน

      @@PowerBiSkills- please sample

  • @bambina5604
    @bambina5604 11 หลายเดือนก่อน

    Great tip, thank you!

  • @kenit925
    @kenit925 11 หลายเดือนก่อน

    Thank you for sharing your skills

  • @pierrejoubert29
    @pierrejoubert29 ปีที่แล้ว

    ThaNK YOU, THIS REALLY HELPED A LOT.

    • @PowerBiSkills-
      @PowerBiSkills- ปีที่แล้ว

      Thanks so much for appreciating my work !!!

  • @scorpionsonya
    @scorpionsonya ปีที่แล้ว

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

    • @PowerBiSkills-
      @PowerBiSkills- ปีที่แล้ว

      Thanks for supporting my work. This motivates me to perform better. 🙏

  • @Kishoresir
    @Kishoresir ปีที่แล้ว

    Excellent teaching 👌👌👌👌

  • @lhdps
    @lhdps ปีที่แล้ว

    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.

  • @lhdps
    @lhdps ปีที่แล้ว

    Did i see someone use a lookup to create new columns instead of using the relationship model?

  • @rahulpujare6640
    @rahulpujare6640 ปีที่แล้ว

    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.

    • @PowerBiSkills-
      @PowerBiSkills- ปีที่แล้ว

      Thanks Rahul !! I will make this video.

  • @madhavyedle4944
    @madhavyedle4944 ปีที่แล้ว

    Sir please make video on future N month trend in power bi

    • @PowerBiSkills-
      @PowerBiSkills- ปีที่แล้ว

      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.

  • @chaitanyalanka7043
    @chaitanyalanka7043 ปีที่แล้ว

    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

    • @PowerBiSkills-
      @PowerBiSkills- ปีที่แล้ว

      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.

  • @chaitanyalanka7043
    @chaitanyalanka7043 ปีที่แล้ว

    Very useful

  • @chaitanyalanka7043
    @chaitanyalanka7043 ปีที่แล้ว

    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

  • @chaitanyalanka7043
    @chaitanyalanka7043 ปีที่แล้ว

    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

  • @monubhaiya9022
    @monubhaiya9022 ปีที่แล้ว

    Thanks you sir for teaching

  • @PallaviKavin
    @PallaviKavin ปีที่แล้ว

    its work for single selection can you show it for multiple selection

    • @PowerBiSkills-
      @PowerBiSkills- ปีที่แล้ว

      Sure !! Multiple selection can be possible with Data modelling Field parameters functionality.

  • @AmanKumar-eb5vd
    @AmanKumar-eb5vd ปีที่แล้ว

    Nice video ❤

  • @Ayman154
    @Ayman154 ปีที่แล้ว

    thanks great

  • @Coglitics
    @Coglitics ปีที่แล้ว

    I like how you teach.

  • @usmanshani2
    @usmanshani2 ปีที่แล้ว

    Hi, Thanks for this wonderful tutorial. Can you create gantt chart with SVG in matrix?

  • @DatawithHimanshu
    @DatawithHimanshu ปีที่แล้ว

    Thank you for awesome contents.

  • @arshkaur8091
    @arshkaur8091 ปีที่แล้ว

    Amazing video and briefly explained. Thank you sir making these learnings available for us 🙂

  • @akshithareddy601
    @akshithareddy601 ปีที่แล้ว

    That works for 1 year. What if you have to do with multiple years

    • @PowerBiSkills-
      @PowerBiSkills- ปีที่แล้ว

      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.

  • @rafaelannibale1697
    @rafaelannibale1697 ปีที่แล้ว

    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

  • @SrinivasN-jo4cq
    @SrinivasN-jo4cq ปีที่แล้ว

    Thank you so much sir. New version features are not available. But you put the new version feature. Thank you

  • @skumar05
    @skumar05 ปีที่แล้ว

    Hello sir