Forum

Notifications
Clear all

13 months roll sorting in graphs

2 Posts
2 Users
0 Reactions
77 Views
(@pat)
Posts: 23
Eminent Member
Topic starter
 

Hi,

 

Apologies. I cant seem to add this inquiry in the Power BI forum.

 

How can I sort the 13 months in the graph, example from Sept 2021 until Sept 2022. Currently its jumbled though technically I just copied this from the new version of PBI. I just need to redo it on the lower version to be compatible on our office's server.

pbi-13-months-roll.jpg

Appreciate the help. 

Thanks.

 
Posted : 07/11/2022 4:46 am
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

Hi Emmanuelle,

Are those dates actually stored as dates?  Or are they text?

If they are not stored as dates then they won't sort correctly.

Regards

Phil

 
Posted : 07/11/2022 7:03 pm
Share: