Forum Discussion
Helper IDates in chronological order
HI,
I have some difficulties with ordening my dates in chronologic order when i'm making a line graph.
How can that be solved?
Thanks in advance
Hi Ottmar_W,
You need an auxiliary column in your scenario.
1. Add an index in the Query Editor.
2. In the data view, Sort by Column the index.
Best Regards,
Dale
22 Replies
jthomsonSolution Sage
Can you elaborate? if it's a "months sorting alphabetically" thing then add an index column and have your month name column sort on that, but you're not giving us much to go off
ccakjcrxResolver I
Hey!
jthomsonis probably on the right track. You have to go to the model, add a new column (we'll call that column B), and then sort your date column by 'column B.'
There are several thread in the PBI community concerning this issue. Here is a URL that has really good screenshots illustrating what is probably the solution to your problem:
https://blogs.msdn.microsoft.com/samlester/2017/04/02/sorting-by-month-names-in-power-bi/
- ccakjcrxHey!
Absolutely. Send to [email protected].
I’ll be away from my PC from a while. I can get to it in a few hours.
