cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sameergupta60
Helper III
Helper III

Month wise sort help

Hi,

 

in the below screenshot I want to sort coloum by financial year.

Can u guide us.

 

 

sameergupta60_0-1612351735440.png

 

1 ACCEPTED SOLUTION

Hi@sameergupta60

 

You can create a column chart and a slicer with month name field ,then sort the month name with the fiscal year number field.

 

For more information about sorting Data by Fiscal Year in Power BI,you can refer to this :

https://powerobjects.com/tips-and-tricks/sorting-data-fiscal-year-power-bi/ 

 

Hope it helps.

 

Best Regards,

Caitlyn Yan

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

8 REPLIES 8
sameergupta60
Helper III
Helper III

Can u guide us on how to make it into financial year sort?

Hi@sameergupta60

 

You can create a column chart and a slicer with month name field ,then sort the month name with the fiscal year number field.

 

For more information about sorting Data by Fiscal Year in Power BI,you can refer to this :

https://powerobjects.com/tips-and-tricks/sorting-data-fiscal-year-power-bi/ 

 

Hope it helps.

 

Best Regards,

Caitlyn Yan

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Tahreem24
Super User
Super User

Follow this screen shot:

Capture.PNG

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , and Fortune 500 Companies Analysis
Tahreem24
Super User
Super User

Your Date column is not  a Date type. It's a text type. 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , and Fortune 500 Companies Analysis

I will explain what I have done.

 

I have a date column which I using Dax format &  convert into "MMM YYYY"

 

Month Name = FORMAT(allbar[Finish],"MMM YYYY")
 

@sameergupta60 ,

After that change the format from Text to Date like below screen shot.

Capture.PNG

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , and Fortune 500 Companies Analysis

sameergupta60_0-1612353336541.png

 

@sameergupta60 ,

Is there any junky or blank value in that Date column? can you share sample of that original date column?

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , and Fortune 500 Companies Analysis

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.