BI With Gurpreet
BI With Gurpreet
  • 15
  • 84 759
How to do custom sort in Power BI? - recommended method and best practices!
This is quick and powerful Power BI tutorial on how to set a custom sort order for your charts, legends, or values! This is definitely something you should add to your Power BI skills.
If you have a text column in your chart, legend or slicer, and you want to sort it based on a different order than the normal alphabetical order, then watch this video to learn the method.
In this video, I have also shared some of the best practices, that you should keep in mind when using these custom sort methods.
--------------------------------------------------------------------------------------------------------
✅ DOWNLOAD FILES:
Download exercise files used in this video: tinyurl.com/yc29w4a5
--------------------------------------------------------------------------------------------------------
⏱️TIMESTAMPS:
00:00 Why is the need to learn custom sort?
03:21 THIS METHOD IS NOT RECOMMENDED - Only use this method for POC etc.
04:20 METHOD 1 to apply custom sort
09:02 METHOD 2 to apply custom sort
13:58 Hide table and columns from Report view
16:20 THE CHALLENGE - can you custom sort the Marital Status column?
17:01 Quick RECAP
🙏🏽 FORM TO REQUEST VIDEOS :
forms.gle/4BFcH6msQEwuBrEU9
--------------------------------------------------------------------------------------------------------
🔔 SUBSCRIBE!
Do you want to become a Data Analyst or a BI Analyst? That's what this channel is all about! My goal is to help you learn the skills, knowledge and tools to successfully launch a career in Data Analytics. Be sure to subscribe to not miss out on any content! -- @biwithgurpreet
--------------------------------------------------------------------------------------------------------
🔽 CONNECT WITH ME:
Instagram: biwithgurpreet
มุมมอง: 3 492

วีดีโอ

Basket Analysis using Power BI - Intermediate DAX Power BI Project | Power BI Mastery
มุมมอง 14Kปีที่แล้ว
In this video we will be learning all about basket analysis and how to perform it in Power BI, in the form of a complete project. This is an intermediate level project, with focus on learning and writing a bit complicated DAX formulas and functions, to to data analysis required in order to effectively perform basket analysis. ✅ DOWNLOAD PROJECT FILES: Download Microsoft Power BI file: tinyurl.c...
End to End Power BI Project - Customer Churn Analysis | Power BI Mastery #powerbitraining
มุมมอง 44Kปีที่แล้ว
In this video, you can follow-along, to create and publish a complete Power BI Report for Customer Churn Analysis. The is a completely hands Power BI Report tutorial, for beginners, to go from raw data to a finished report. In this video, we take Bank Customer Churn dataset and go through the end-to-end process of developing and publishing the Customer Churn Analysis report in Power BI, includi...
2.2 Power Query Editor User Interface - Complete walkthrough | Power BI Masterclass 2023 #powerquery
มุมมอง 668ปีที่แล้ว
Welcome to the Power BI Masterclass. This video is part of the complete end to end, beginner friendly Power BI Training on TH-cam, with all the exercise files provided. In this video, I will introduce you to Power Query Editor user interface and show you the 7 key parts of the Power Query Editor window: 1. Ribbon 2. Queries Pane 3. Data Pane 4. Query Settings Pane 5. Formula Bar 6. Preview Pane...
2.1 Power Query Data Connectors & Data Connections | Power BI Masterclass #powerbitutorial
มุมมอง 966ปีที่แล้ว
Welcome to the Power BI Masterclass. This video is part of the complete end to end, beginner friendly Power BI Training on TH-cam, with all the exercise files provided. In this video, I explain the following concepts in detail: 1. What is a data connector? 2. Details of Data connectors in Power BI Desktop 3. Understand different types of Data Connections 4. Import vs DirectQuery vs LiveConnecti...
Bikeshare Power BI Report - Step by Step | Power BI Project #powerbitraining
มุมมอง 4.9Kปีที่แล้ว
Welcome to the Power BI Masterclass. This video is part of the complete end to end, beginner friendly Power BI Training on TH-cam, with all the exercise files provided. In this video, you can follow-along, to create and publish your first Power BI Report. The is a completely hands Power BI Report tutorial, for beginners, to go from raw data to a finished report. In the next video, we take the B...
1.3 Understanding the Power BI Desktop Workflow | Power BI Masterclass #powerbitraining
มุมมอง 725ปีที่แล้ว
Welcome to the Power BI Masterclass. This is a complete end to end, beginner friendly Power BI Training with all the exercise files provided. This is the third video in the Power BI Masterclass. In this video, you will: 1. Understand the typical workflow within Power BI Desktop 2. Learn the steps to go from raw data to a finished report within Power BI Desktop 3. How the Power BI Workflow align...
1.2 Power BI Desktop Installation and detailed walkthrough | Power BI Masterclass #powerbitraining
มุมมอง 594ปีที่แล้ว
Welcome to the Power BI Masterclass. This is a complete end to end, beginner friendly Power BI Training with all the exercise files provided. This is the second video in the Power BI Masterclass. In this video, you will learn: 1. How to download and install Power BI Desktop 2. Complete walkthrough of the Power BI Desktop user interface 3. How to change the options and settings Chapter links: 00...
1.1 Introduction to Power BI | Power BI Masterclass with Exercise Files #powerbitraining
มุมมอง 1.1Kปีที่แล้ว
Welcome to the Power BI Masterclass. This is a complete end to end, beginner friendly Power BI Training with all the exercise files provided. In the video, we cover: 00:00 Introduction to Power BI Masterclass 01:18 What will you learn in this video? 02:12 What is Business Intelligence? 02:56 Benefits of Business Intelligence 04:08 The 5 Step BI Process 09:31 What is Power BI? 10:54 Key componen...
How to RESHAPE Subcategorised data into a table with Power Query #powerbitutorial
มุมมอง 2.4Kปีที่แล้ว
In this video you will learn how to reshape subcategorised data (data with multiple header rows), with Power Query, into nicely formatted tabular format. Chapter Links: 00:00 What are we going to learn? 01:09 Review the raw data and the data transformation challenge 02:15 Connect to data in the excel file 03:01 Power Query Editor - applied steps cleanup 04:00 Power Query Editor - remove top row...
How to RESHAPE Horizontally Stacked data into a table with Power Query #powerbitutorial
มุมมอง 3.6Kปีที่แล้ว
In this video you will learn how to reshape multi column horizontally stacked data into a table, with Power Query. Chapter Links: 00:05 Review the source data and understand the challenge 00:56 Connect to the data source (.xlsx file) 02:27 Review and cleanup the (Auto) Applied Steps 03:09 The technique to reshape multi column horizontally stacked data 06:47 The technique to promoting headers wh...
How to RESHAPE Multi-Column Stacked Data into a table with Power Query #powerbitutorial
มุมมอง 2.8Kปีที่แล้ว
In this video, you will learn how to reshape multi column vertically stacked data, with Power Query, into nicely formatted tabular format. Chapter Links: 00:00 Introduction 01:05 Review the source data and understand the challenge 03:30 Connect to the data source (.xlsx file) 05:01 The technique to reshape multi column vertically stacked data 08:52 Data Cleanup 10:30 Save transformations and im...
How to RESHAPE Single Column stacked data into a Table with Power Query #powerbitutorial
มุมมอง 1.7Kปีที่แล้ว
In this video, you will learn how to reshape single column stacked data, with Power Query, into nicely formatted tabular format. Chapter Links: 00:00 Introduction 01:03 Review the characteristics of source data 02:26 Connect to the data source (.txt file) 05:08 The technique to reshape single column stacked data 08:45 Data Cleanup 12:05 Save transformations and import data 13:09 Recap Link to t...
How to Import and join multiple text files data with APPEND in Power Query #powerquerytutorial
มุมมอง 1Kปีที่แล้ว
In this video, we will continue from where we left in the PART 1 of working with text files in Power BI. If you haven't watched it, I will highly recommend you to watch and practice the concepts covered in Part 1 first. Part1 - Importing and cleaning messy data from text file - Power Query Tutorial: th-cam.com/video/JZH2y4dystk/w-d-xo.html In this video, you will learn to import and join multip...
How to import and clean messy data with Power Query #powerbitutorial #powerquerytutorial
มุมมอง 2.8Kปีที่แล้ว
In this video, you will learn how to import and clean messy data from a text (.txt) file. Topics Covered: 00:00 Introduction 00:58 Review and identify the challenge at hand 06:30 Connect .txt file using Get Data 08:00 Launch Power Query to Transform Data 09:56 Remove the unwanted header rows 11:33 Promote top row as headers 11:55 Remove blank rows 13:22 Remove the repeated column headers 14:25 ...

ความคิดเห็น

  • @HG-Tech
    @HG-Tech วันที่ผ่านมา

    Great video, very helpful. How did you figure out this process?

  • @md.shamsuzzaman4156
    @md.shamsuzzaman4156 12 วันที่ผ่านมา

    Thanks

  • @md.shamsuzzaman4156
    @md.shamsuzzaman4156 13 วันที่ผ่านมา

    Thanks

  • @md.shamsuzzaman4156
    @md.shamsuzzaman4156 16 วันที่ผ่านมา

    Thanks

  • @md.shamsuzzaman4156
    @md.shamsuzzaman4156 17 วันที่ผ่านมา

    Thanks.

  • @ajitkanabar84
    @ajitkanabar84 22 วันที่ผ่านมา

    Hi Gurpreet, Thanks for the video. I really appreciate your efforts. However though, I have the data as stated below. Col.A - Item Col.B - Qty 1 Col.C - Price 1 Col.D - Qty 2 Col.E - Price 2 and so on... till Qty 10 and Price 10 and would like to transpose/unpivot/pivot to the end result that i am trying to achieve as mentioned below Col.A - each Item repeated 10 times Col.B - Qty (with all the different Qty for each item to be repeated) Col.C - Price (with all their relevant prices for those quantities and items) Because for each item, will have different price points based on the quantities purchased. Hope that makes sense. Would you share some inputs on how this would be realistically possible using powerbi/power query editor? Thanks

  • @Ayushi-e6q
    @Ayushi-e6q 24 วันที่ผ่านมา

    everything is okay but you are not audible even though my system volume is 100 so it is super irritating

  • @atharabbas1224
    @atharabbas1224 28 วันที่ผ่านมา

    Solved my issue. Thanks

  • @md.shamsuzzaman4156
    @md.shamsuzzaman4156 หลายเดือนก่อน

    Excelent. Thank you

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

    Thank u

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

    This trick is really useful! Excellent video, very well explained and quick to watch! Thank you so much!

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

    Hi. Im working with a lot of data so when I want to create the Basket analysis Table it says that there is not enough space. Do you have any suggestions on what I can do?

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

    Why you stopped making video, we needed such great project in this tough time.

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

    Thank you for an excellent tutorial! Is there anything worth considering if I want to add products e.g. Prod 3 and Prod 4 in the basket analysis?

  • @김종휴-g3n
    @김종휴-g3n หลายเดือนก่อน

    Quite helpful to import Association Rule basis analysis as relevant option with easy to follow way. Many Thanks and hope you share more various example of data mining cases on Power BI. Thank you.

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

    Thanks for this video Gurpreet

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

    This is extremely helpful! How would I apply slicers (and where) if I want to look at a specific region or sales channel?

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

    +1 Subs Here!

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

    Thanks for making this Video, I salute you Sir

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

    phew!!!, i got to the end. You are a really good teacher, very detailed.

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

    Thanks for sharing such a great content

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

    This is a masterful video. Thank you so much!!!

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

    How can download the dataset???

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

    Amazing attention to detail, very calm and complete analysis and explanation of the topic. Unfortunately there is no "cleaner" way of achieving this, but I'm happy you confirmed that there is no other option. Will definitely check in again

  • @RashmiKumari-h6m
    @RashmiKumari-h6m 3 หลายเดือนก่อน

    Thank you so much for such an amazing video !!! You have explained it in the simplest way possible. Really Helped

  • @MuhammadYasir-fe3pp
    @MuhammadYasir-fe3pp 3 หลายเดือนก่อน

    Plz

  • @MuhammadYasir-fe3pp
    @MuhammadYasir-fe3pp 3 หลายเดือนก่อน

    Plz sir quick response as you can

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

    Absolutely great video, exactly what I was looking for. The best thing about this is that you started off by explaining the key concepts of support, confidence and lift, which not a lot of youtubers do, since they focus too much on the technical aspects of data without realizing that the true value of such projects lies in the derived business insights. So, thank you for that!

  • @MuhammadYasir-fe3pp
    @MuhammadYasir-fe3pp 3 หลายเดือนก่อน

    Dear sir hope you're well please guide me about excel so that i can earn online

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

    Subscribed

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

    Thank you from Kenya

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

    thanks

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

    Thank you for a fantastic tutorial. It's really helpful practising along. Much appreciated. I have a question about the groupings created for the Account Balance category at the beginning. Could you help me understand how the groupings were decided? In the 'Add conditional column' window, I noticed that there is an overlap between the upper bound of a clause and the lower bound of the clause after it, for example, 1-1k and then 1k-10k. If we were to have someone with an account balance of 1k, it seems uncertain which grouping they would be in.

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

    Thank you soooooo much

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

    in the data set activity status of the customer is active and churn status of the customer is churned ,is it possible?

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

    Suppose now if we refresh our data for june nd july month we get that in this way only?

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

    Load Customer Data Failed to save modifications to the server. Error returned: 'The following system error occurred: Class not registered '. Age Groups Failed to save modifications to the server. Error returned: 'The following system error occurred: Class not registered '. Account Balance Groups Failed to save modifications to the server. Error returned: 'The following system error occurred: Class not registered '. Credit Score Groups Failed to save modifications to the server. Error returned: 'The following system error occurred: Class not registered '. Close STILL FACING THE ISSUE

  • @KiranKumar-od6rc
    @KiranKumar-od6rc 5 หลายเดือนก่อน

    Hi, Can we use Product1<>product2 (not equal) instead greater than. How greater than works here?

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

      So that the product combinations shouldn't be repeating like (Milk --> Bread) or (Bread --> Milk)

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

    For a Calendar table, Its not at all a best practice to use static date range. Use Min and Max function instead and make it dynamic. Just a suggestion from my end...

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

    Every videos of your channel help the aspiring data analyst like me. Honestly, I really want to learn more and it’s a great learning curve. Please do more videos, it’s really helping us.

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

    Amazing, the way you did the complete process from scratch and explained each topic. Thank you!, Please upload a video on another POWER BI project in the FMCG Domain. Today I learned so many basic things and concepts that we need to follow during the analysis. Thank you once again, the way you teach is simply awesome! 👌👌💐💐

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

    This video is under rated. It ought to have gotten over a million views. I am thrilled by the simplicity of your teaching. Take your flowers please💐💐💐💐💐

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

    Hi , the Advanceed Network Filter light is no longer an option. Is there an alternative way to access this? thanks

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

    Great video. Tried following along but apparently, I couldn't get the "network" chart from Get More Visuals as they are all now paid. Please, is there any other available chart that isn't paid that I can use to visualize the basket?

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

    Very cool, but what if I wanted to refer it to several stores and divide it into a specific date and store? In one word, I would have to add 2 columns to this example, but then the "index" column will not be correct because it should be counted differently for each store, maybe someone can link the example I gave because it is a bit more realistic :)))))

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

      You need to create a concatenated column with the store, date and transaction id to make it unique

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

    Fantastic tutorial. Super clear and easy to follow. You are an excellent teacher!

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

    Hello Gurpreet, I'm trying to find solution with this project. But my data source has more columns than yours such as: Card Type (Diamond, Platinum, Gold, Silver), Complain (1, 0). My goal is Analysis of Customer Churn Relationships is my goal. I hope that you will give me some recommendation. Thank you so much <3

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

    loved your content please cover major topics regarding powerBI your explanation is so simple and easy to grasp please sir make a complete video on Powerbi from basics to more advanced functions with real source data it would be beneficial for many of us.