Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
raju8004
Frequent Visitor

Max function not supported sort by in barchart

When I'm trying to create a bar graph with 

Reporter name in yaxis and dax formula 

Of calculate(max(sales),date>mindare&&date<maxdate) along with quater on legend not able to sort the visual it's showing random sort not exact sort can any one please help

1 ACCEPTED SOLUTION
v-sdhruv
Community Support
Community Support

Hi @raju8004 ,

You can use the date column to sort it with Quarter column.
Check these links which might help-
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column
https://community.fabric.microsoft.com/t5/Desktop/How-to-sort-by-year-and-quarter/td-p/1121335
Additionally, it would be better if you could provide more context to your exact problem with sample data and expected output so that we can help with the issue.

Thanks!

View solution in original post

5 REPLIES 5
v-sdhruv
Community Support
Community Support

Hi @raju8004 ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

v-sdhruv
Community Support
Community Support

Hi @raju8004 ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

v-sdhruv
Community Support
Community Support

Hi @raju8004 ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

v-sdhruv
Community Support
Community Support

Hi @raju8004 ,

You can use the date column to sort it with Quarter column.
Check these links which might help-
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column
https://community.fabric.microsoft.com/t5/Desktop/How-to-sort-by-year-and-quarter/td-p/1121335
Additionally, it would be better if you could provide more context to your exact problem with sample data and expected output so that we can help with the issue.

Thanks!

lbendlin
Super User
Super User

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors