BI With Gurpreet
BI With Gurpreet
  • 15
  • 92 989
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
Переглядів: 4 394

Відео

Basket Analysis using Power BI - Intermediate DAX Power BI Project | Power BI Mastery
Переглядів 16 тис.Рік тому
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
Переглядів 48 тис.2 роки тому
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
Переглядів 7562 роки тому
Welcome to the Power BI Masterclass. This video is part of the complete end to end, beginner friendly Power BI Training on UA-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
Переглядів 1 тис.2 роки тому
Welcome to the Power BI Masterclass. This video is part of the complete end to end, beginner friendly Power BI Training on UA-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
Переглядів 5 тис.2 роки тому
Welcome to the Power BI Masterclass. This video is part of the complete end to end, beginner friendly Power BI Training on UA-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
Переглядів 7962 роки тому
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
Переглядів 6172 роки тому
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,1 тис.2 роки тому
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,5 тис.2 роки тому
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,8 тис.2 роки тому
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,9 тис.2 роки тому
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,7 тис.2 роки тому
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
Переглядів 1,2 тис.2 роки тому
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: ua-cam.com/video/JZH2y4dystk/v-deo.html In this video, you will learn to import and join multipl...
How to import and clean messy data with Power Query #powerbitutorial #powerquerytutorial
Переглядів 3 тис.2 роки тому
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 ...

КОМЕНТАРІ

  • @onemoreshot-eb3rt
    @onemoreshot-eb3rt 11 днів тому

    best video i have seen so far clear simple and highly educating thanks sir.

  • @letsdomistakes
    @letsdomistakes 17 днів тому

    Sir could you suggest me some books for real world business application using Power BI and increase business understanding so that during dashboard creating i could make according to business need and I could give some recommendation as per visualization. Sir please share me lists books name.

  • @mukeshkumaryadav350
    @mukeshkumaryadav350 23 дні тому

    Great work

  • @tarun2428
    @tarun2428 23 дні тому

    Dear Gurpreet, thank you for the video, this has been very well demonstrated and easy to understand. I have a small query, if you can help - in the slicer 'Churn Status' if I have to also use ALL but have to rename it to something else, maybe 'Both', then how to do this. And once this done, how to custom sort this slicer to always keep the "Both" on top.

  • @NmesomachukwuOnyeka
    @NmesomachukwuOnyeka 25 днів тому

    thank you so much

  • @shakesrear7850
    @shakesrear7850 Місяць тому

    Thank you

  • @atulshinde5343
    @atulshinde5343 2 місяці тому

    Wow Sir, Nice Showing All the thing.......One by one ...its really affirmative.......Pls make dax series sir....

  • @hichambalafrej7543
    @hichambalafrej7543 2 місяці тому

    Dear Gurpreet, many thanks for the explanation it’s really very useful and well detailed, thank you very much. Just one point, I’m struggling to understand the filter effect applied on the Crossjoin function. I’ve understood the result but the logic behind is a bit fuzzy for me, when we say [Product1]<>[Product2] or [Product1]=[Product2] it’s more or less clear, but [Product1]>[Procuct2] or vice versa especially when we deal with a text fields. I’m a little bit lost regarding this point. Is their any logic behind or should I take it like that and move forward? Many thanks.

  • @dajanabushpepa4389
    @dajanabushpepa4389 2 місяці тому

    That was amazing tutorial literally detailed the best

  • @marketxaniotakis
    @marketxaniotakis 2 місяці тому

    I LOVE YOU MAN!

  • @HG-Tech
    @HG-Tech 3 місяці тому

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

  • @md.shamsuzzaman4156
    @md.shamsuzzaman4156 3 місяці тому

    Thanks

  • @md.shamsuzzaman4156
    @md.shamsuzzaman4156 3 місяці тому

    Thanks

  • @md.shamsuzzaman4156
    @md.shamsuzzaman4156 3 місяці тому

    Thanks

  • @md.shamsuzzaman4156
    @md.shamsuzzaman4156 3 місяці тому

    Thanks.

  • @ajitkanabar84
    @ajitkanabar84 3 місяці тому

    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 3 місяці тому

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

  • @atharabbas1224
    @atharabbas1224 3 місяці тому

    Solved my issue. Thanks

  • @md.shamsuzzaman4156
    @md.shamsuzzaman4156 4 місяці тому

    Excelent. Thank you

  • @tanakornpromthep9025
    @tanakornpromthep9025 4 місяці тому

    Thank u

  • @fernandocardinali1683
    @fernandocardinali1683 4 місяці тому

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

  • @key-zw2so
    @key-zw2so 4 місяці тому

    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 4 місяці тому

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

  • @MrAkerblom
    @MrAkerblom 4 місяці тому

    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 4 місяці тому

    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 4 місяці тому

    Thanks for this video Gurpreet

  • @NN-Analytics
    @NN-Analytics 4 місяці тому

    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 5 місяців тому

    +1 Subs Here!

  • @MarcDominicCoching
    @MarcDominicCoching 5 місяців тому

    Thanks for making this Video, I salute you Sir

  • @emmanuelesheku7125
    @emmanuelesheku7125 5 місяців тому

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

  • @majeedadil777
    @majeedadil777 5 місяців тому

    Thanks for sharing such a great content

  • @PillsLifestyleReviews
    @PillsLifestyleReviews 5 місяців тому

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

  • @hashangeorge9476
    @hashangeorge9476 5 місяців тому

    How can download the dataset???

  • @fluffigverbimmelt
    @fluffigverbimmelt 5 місяців тому

    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 6 місяців тому

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

  • @MuhammadYasir-fe3pp
    @MuhammadYasir-fe3pp 6 місяців тому

    Plz

  • @MuhammadYasir-fe3pp
    @MuhammadYasir-fe3pp 6 місяців тому

    Plz sir quick response as you can

  • @uzairmughal9383
    @uzairmughal9383 6 місяців тому

    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 6 місяців тому

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

  • @mayurmehta7011
    @mayurmehta7011 6 місяців тому

    Subscribed

  • @bundikimaita5468
    @bundikimaita5468 6 місяців тому

    Thank you from Kenya

  • @ManishThilagar
    @ManishThilagar 6 місяців тому

    thanks

  • @moaishh
    @moaishh 7 місяців тому

    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 7 місяців тому

    Thank you soooooo much

  • @Factstelugu5
    @Factstelugu5 7 місяців тому

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

  • @abhinavsachdeva7934
    @abhinavsachdeva7934 7 місяців тому

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

  • @codewithashw
    @codewithashw 7 місяців тому

    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 8 місяців тому

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

    • @majeedadil777
      @majeedadil777 5 місяців тому

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

  • @deepakr8794
    @deepakr8794 8 місяців тому

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