Forum Discussion
Solved
Date not sorting properly on line graph
I have created a column in the format of FY19 Q1 on my Dim-Date table that I intend to use for fiscal quarter date sorting. I am using tihs same column in a line chart and a matrix table. The matri...
Finally, you explained the full issue. Yes, it is a known issue (or how it works) if you are using field parameters, it doesn't retain the sort order. I would recommend using calculation groups to switch between measures (you will get the same result as FP) but it will retain the sort order. That is what you need to do.
parry2k
Super User
Super UserDev_B_PBIing click on top of the line visual (3 dots) and you can change the sorting order and sorting column there.
Yes, when I do that it doesn't hold the sort though. when I told it to sort ascending it does fix it, but it doesn't stay that way. Is there a way to make it remain in ascending order?