Hi,
I created a sort column for my dataset and sort the data with that column. However, my date axis in my visual is still not sorted. Some help please? Thank you.
I will also enclose my PBIX file here: https://www.dropbox.com/s/mcvemjaq1166wsc/Price%20Analyser%20Date%20request%20help%20%28sort%20Colum...
I downloaded your file and got it working from your existing Sort column. In Data View, highlight/select the Month & Year column, then on the ribbon choose Sort By Column and choose the Sort column. Then, if needed, hit the ellipsis on the visual and choose to sort it by Month & Year and Ascending.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi Pat!
I did what you instructed and I still see the following. Any idea where else went wrong?
Hi @fanhui3
I downloaded your sample pbix file and got the following solution:
The sort order of the chart axis changes immediatly.
With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)
HI @FrankAT
I tried your method. and just like PAT's method, there are still some months that can't be sorted with the rest of the months. See circled in red of third picture.
At this point, I am starting to think there are problem with my software instead of the solutions.
Oh yea, I would like to add. The problem only persist in scattered graph. Weird.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
User | Count |
---|---|
433 | |
190 | |
106 | |
57 | |
49 |
User | Count |
---|---|
456 | |
219 | |
128 | |
75 | |
71 |