Forum Discussion
Issue sorting a column (Time constraint) on X-axis with multiple same text values/labels
Seeking help to have the highlited column sort on X-axis based on a switch between Month and quarters, the visual sorts as expected for Month Labels, however it won't for Quarter labels (hence the values are not unique to sort based on an other column) (unique Key on Fiscal Month Key),
I tried creating Index column or a sort column, however I'm running into error with multiple values for a unique value in an other column, or a circular dependency.
I'd be grateful for one of you can show me a direction into solving this. I have exhausted some previously provided solutions and hoping to see if they are any other means. Thanks so much in advance
10168 ,
Tried doing some quick research. Came across the following:
https://www.youtube.com/watch?v=TLiqqIsk1CU
1st comment is this:
11 Replies
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 !!
Numerous youtube videos on Bookmarks if you wanna take the time. Much better explained than I can do here.