Need a little more information on your data, particularly the dates. I generally do not have a problem with this if the dates are actual dates like 7/24/2015 and flagged as a date versus text or something. Where I have run into issues before is when I want to have a month name appear in a chart and it sorts it alphabetically. In those cases, I create a "MonthSort" column which has the numeric value of the month 1-12 and set the "Sort By" field for the "Month" column to be the "MonthSort" column.
Hopefully this helps, not much to go on.
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Mastering Power BI 2nd Edition
DAX is easy, CALCULATE makes DAX hard...
Need a little more information on your data, particularly the dates. I generally do not have a problem with this if the dates are actual dates like 7/24/2015 and flagged as a date versus text or something. Where I have run into issues before is when I want to have a month name appear in a chart and it sorts it alphabetically. In those cases, I create a "MonthSort" column which has the numeric value of the month 1-12 and set the "Sort By" field for the "Month" column to be the "MonthSort" column.
Hopefully this helps, not much to go on.
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Mastering Power BI 2nd Edition
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
Power BI Monthly Update - November 2023
Check out the November 2023 Power BI update to learn about new features.
Fabric Community News unified experience
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Exclusive opportunity for Women!
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
The largest Power BI and Fabric virtual conference
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.
