Forum Discussion
Helper IIISort chronologically x axis based on date and time column
Hello Anonymous ,
Thank you for your answer.
Comparing with your data, I thought everything was equal, but then I noticed that the problem was related to the legend. In fact, when I excluded it, dates are sorted chronologically.
I think the problem is related to the model structure. The chosen column for the legend is from another table. This table is not connected directly to the table that I'm using for the values on the y and x axis and the relationship between both tables are many to many. Now I'm trying to recreate the model to be possible to include the legend and keep x axis sorted chronologically.
Best regards,
Super Uservalcat27 if you click on "sort by" are you sure it is the same column as used on x-axis. I think you mentioned it is, but can you share the screenshot, it doesn't make sense at all.
Helper IIIYes, I’m sure. I also tried to change it to “sort by y –axis” to validate and the dates appear more random (than before) like 2018, 2019, 2016, 2014, 2019, 2019, 2019. Moreover, when I select “sort by date column” and “sort descending”, the first dates appearing in the visual are in fact the last years, but again sorted only partially chronologically.
- Pragati11
Hi valcat27 ,
Apologies for jumping in here.
This is weird. Is it possible for you to share your pbix file after removing any sensitive information?
Thanks,
Pragati
- valcat27
I'm sorry but unfortunately I cannot share my pbix file... I cannot share more than the type of print screen /information that I have shared here
