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 va...

Need Help

Tutorial Requests

rsbin
3 years ago
10168 ,

Tried doing some quick research. Came across the following:

https://www.youtube.com/watch?v=TLiqqIsk1CU

1st comment is this:

3 weeks ago

Fernan, I have a challenge for you: I’m using the field parameter para switch the time series of my visuals between Year and Fiscal Week. I want to keep X axis sorted by the time series (not by the values) in ascending order. However, every time I switch the field, the X axis is sorted back by the values. It’s driving me crazy!!!
Sounds like your exact issue. I suggest you perhaps start another thread with this more specific issue. There are probably others in the Community that have encountered this as well.

Otherwise using Bookmarks with Buttons would easily solve for this. It's a very similar concept, create buttons, and then these buttons hide and show specific visuals. So basically you have one Visual exactly on top of the second with that one hidden from view. The Buttons then are used to flip the view.
Numerous youtube videos on Bookmarks if you wanna take the time. Much better explained than I can do here.
Guy In a Cube or
this guy https://www.youtube.com/watch?v=_HTF7Ph7Eqc
Hope this helps. If you want to go down this path, I can assist but urge you to at least try on your own. Looks to me like you would grasp this quite quickly.
rsbin
3 years ago
10168 ,

Your Column [Fiscal Quarter Year] is simply a text value.

So sorting alphanumerically,

FY19-20 Q1 comes before

FY19-20 Q2 etc..

Similarly,

FY19-20 comes before

FY20-21 which comes before

FY21-22.

So always better to have yyyy-mm in your axis rather than mm-yyyy.

Does this explain it?

Forum Discussion

Issue sorting a column (Time constraint) on X-axis with multiple same text values/labels

Related content

charticulator's constraints

MLV Constraints

If Fabric Mirroring lost Constraints

MULTIPLE CARD

Data label values shows twice