Forum Discussion
Issue sorting a column (Time constraint) on X-axis with multiple same text values/labels
10168 ,
Tried doing some quick research. Came across the following:
https://www.youtube.com/watch?v=TLiqqIsk1CU
1st comment is this:
Thank you ! that was great recommendation, I see how switching would benefit me into sorting, The axis does sort when I sort axis in the visual by the Fiscal Quarter Label, and Asc, however it defaults back to previous based on the parameter selection, the parameter is too important for me as it lets my end user switch between the labels for Months and Quarters
Do you have any recommendations to avoid that? Please and thank you !!
10168 ,
I've never used Parameters to change Axis. Have always used Bookmarks to do this. I would simply update my Bookmark.
So I don't fully understand when you say "it defaults back to previous based on the parameter selection"?
I will look into Bookmark, thanks for that suggestion, the parameters is a new feature for me as well, I mean this below, goes back to how I would see without sorting
10168 ,
Looks to me like the chart is sorting your "Multiplier" in Descending Order.
You should be able to click the elipsis in the top right corner of the visual and sort Axis in Ascending order.
Or please attach your pbix file and I can have a closer look. Please scrub any sensitive data before doing so.
Yes it is, however I was able to click ellipses and change it, but when I unselect and select months and come back, and select Quarters again, it sorts by multiplier than axis, I wish it could remain as saved but it won't, a bookmark works but I am not knowledgable enough to know if I can throw the book mark onto the visual for my end user to click it
Numerous youtube videos on Bookmarks if you wanna take the time. Much better explained than I can do here.