About This Artical In Power Bi

In this article, we will learn how we can solve the sort issue of month names in Power BI. Basically, when we apply month names in text format it will auto arrange the month names in alphabetical order. So, to arrange them in a proper form we need to sort month names by the month number.

I have some sample data with products and based on month wise

power bi

I have created the below chart using my data.

As shown in the figure it does not show the month names in sequence.

po

Now, let’s follow the below procedure to sort data by month names.

Step 1:

Make sure the datatype of the month number is a whole number.

power bi

Step 2:

Go to Modelling and select column name “Month Name” and from Ribbon select Modelling and click on Sort by – “Month Number”.

power bi

Step 3:

Check the result.

power bi

For any Help or Queries Contact us on info@crmonce.com or +919014146800

https://www.crmonce.com/power-bi/

We have started a new online retail store    Please Visit.