 Hey guys, welcome to SSUnitech, Sushil this side and this is continuation of Power BI scenarios. So today we are going to see about the custom sort in the Power BI and in this video we will see step by step how we can do the custom sorting. So our base data that we are using for source is sales data. So here we are displaying the sum of order quantities and in the access we are displaying the months. So in this column chart you can see it is starting from April, then August, then December, then Feb, then Jan. So it is sorted according to the alphabets but this is not our requirement. Our requirement is we just want to see the data that will be started from Jan to December. In the case one you can see it is Jan, Feb, March, April till December. So this is our first scenario, go to our second scenario. In the second scenario you can see we are having the current month that is first that is July, then August, September till December after that it will be started to Jan to our last month. So we can see Jan, Feb, March, April, May and June. So that is our last month. So this is our requirement. So how we can do that? So go to on the blank Power BI desktop and here first of all let me select the data. So our data is in Excel. So we can click on that. We can select the source and click on open. If you are needed then you can drop your email IDs in the comment box. So I will send the source file to you. Here we can select this sheet and click on load. It should be loaded successfully. So here it is loaded. So first thing that we need to have the column chart. So we can click on the column chart, make it bigger and here we just want to display the order quantities. So we can drag and drop the order quantity in the values and here we can check it should be some. So that is fine. After that in the access we just want to display the months. We can drag and drop the months in the access. So here we can see it is sorted according to the order quantities. We do not want sort like that. So go to on the more option in the right top and click on these three dots. After that you can see it should be in ascending order first. So we click on that. After that we can again click and go to on sort by in months. So here we can see it is started from April, August, December because it is sorted according to the alphabets. So the first thing that we need to have Jan, then Feb, then March going forward. So for that I just want to add one more column on this source data and that will have the date. So here we can see it is July. So we just want to have the July in the date like 0701, 2019 or 2020. In the year you can specify anything. In the date you can specify anything according to your convenience. But in the month you should specify 07. Let us do in practical. So here go to on the table tools and add a new column. So we can click on that and we need to wait few seconds. So here we can see we can call this as date new and after that we can check if the month is Jan, then 0101, 2020 then put comma. After that you can use the if again the month is Feb then it should be 0201, 2020. In the year you can specify anything as per your convenience. Let me try to make it bigger and here let me paste this 5, 6, 7, 8, 9, 10, 11, 12. After that you can close all these brackets. Now here it is taking for Feb next it should be March. So we can check for March, then April, then May, after that June, then July, then August, September, October, November and December. And here it should be 3, 4, 5, 6, 7, 8, 9, 10, 11 and 12 and you can commit this. After that you can see the new column that should be added at the last you can select that column and you can check the values on that. Here in the right side you can click on that column and go to on column tools and here you can click on this text and change the data type as date. You can click on yes. Now you can see the data. Now go to on our report part. Now let me add a new page and call this page as case 1. Now let me select the column chart try to make it bigger and this time drag and drop this date new in the axis and after that order quantity in the values. Here you can see the 2020 but we don't want to see the data as per year, as per quarter, we will see the data as per month. So here we can see January, March, April going forward till December. So this is our case 1. Now move to case 2. So for that you have to create a new table. Now click on that table and let me call this as custom sort. The column 1 it should be month, the column 2 it should be ID. So in the month it should be Jan, Feb, March, April, May, then June, July, August, September, October, November and December and we just want to start from July. So we can put it as 1, then 2, then 3, then 4, then 5, then 6. You can set these orders according to your requirement. Then 7, 8, 9, 10, 11, 12. So it will be displaying the data that will be started from 1 and going forward. After that you can click on load. So it will be loaded successfully. So we need to wait few seconds. So here you can see custom sort is loaded. Now go to on the relationship and here as you can see it is already built the relationship. So that is fine. If it is not then you have to maintain the relationship manually. Now go to on the report view. Let me add one more and call this as case 2. Now let me select the column chart and make it bigger and here you can see the order quantity. So we can drag and drop in the values. After that don't need to take the months from our base table. Go to on the custom sort that we have created new one and try to drag and drop the month in the axis. So here we can see it is starting from July. So that is not correct. Click on these three dots after that in ascending order. Again click then month. So it is having like April, August, December. So it is not done at yet. So go to on the data view and here go to on that table that we have created. After that select the ID by which we want to do the sorting. Then go to on the column tools. Then right side you can see this option. So in this option you need to select the ID. So now it should be sorted according to the IDs. Now go to on report it is not. So go again and let me do again. Now it should be. Now it is working. Now go to on the report view and here we can see the July, then August, then September, October, November, December. After that Jan, Feb, March. So this is as we want. If we want to display like Jan, then March, then May, then anything then we can set the values that we have specified in the numbers. So I hope guys you have understand how we can do the custom sorting in the Power BI. If you need the source file then you can drop the email on the comment box. So I will send the file. Thank you so much guys for watching this video. If you like this video please subscribe our channel to get many more videos. Don't forget to press the bell icon to get the notification of our newly uploaded videos. Thank you so much. See you in the next video.