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...
exactly the same thing happens to me, I have tried everything they indicate but it still does not change the order in the graph.
In 'data' it is sorted by the column idmes:
But then the graph is sorted from lowest to highest (and the most recent is left at the end:
Also when I hit the 3 points of the visual object, sorting does not allow me to select the idmes (I have it in columns).
It just lets me sort by the fields that are in rows and Values (which start with p and C):
Would anyone know how to help me? why doesn't you allow me to order by month?
Thank you very much!
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.
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)
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.
Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.
Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!
Watch Session 22 Ted's Dev Camp along with past sessions!
Click here to read more about the May 2022 updates!