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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
sophie63
Helper I
Helper I

Date sorting problem

I have an issue with my x-axis which is not sorted in chronological order. I created a column to ahh index from 1 (jan 2016) to 15 (Mar 2017) but even the index are not well sorted.

 

 How can I solve this issue?

dateprob.PNGmonthnumber.PNG

1 ACCEPTED SOLUTION

@sophie63

 

hi, your index is type number or text?. Should be number.

 

 




Lima - Peru

View solution in original post

3 REPLIES 3
sophie63
Helper I
Helper I

Hi,

I have an issue with my x-axis which is not sorted in chronological order. I created a column to ahh index from 1 (jan 2016) to 15 (Mar 2017) but even the index are not well sorted.

 

 How can I solve this issue?

 

dateprob.PNGmonthnumber.PNG

@sophie63

 

hi, your index is type number or text?. Should be number.

 

 




Lima - Peru

@Vvelarde indeed it was Text instead of number I  figured that out after posting ! I changed the type and the problem is solved. Thanks! 🙂

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.