Trick to sort Axis by Bins and have it Appear like the Picture Included in My Post

[villasenorbritt]

I have done this before but can not for the life of me remember how to get the axis to sort the data the way shown in the picture below. I seen it somewhere and the guy who did it explained that he was not sure how/why this method worked, but it ended up making the axis look great when when drilling down on time duration bins. I have a picture of my old Bi project where I was able to accomplish this but have tried what I thought I had done and its not working. It was something weird like drill down, adjust how you sort the axis. But, I cant get it to work. Here is the example:

Any ideas?

[KNP]

Are you talking about the verticle text or just the layout in general?

What have you got it looking like currently?

[villasenorbritt · Accepted solution]

I just figured it out. My apologies. I had been working on this for awhile and then realized I have to turn off concatonate labels for it to appear the way I was wanting. Thanks for your effort!

[villasenorbritt]

I'm talking about the way it groups the x axis. I currently have it looking like this when I drill down to the 60 minute intervals where it puts the date next to the intervals so there are lots of repeating dates and its hard on the eyes:

And when I drill down further to the 30 minute intervals, it looks like this:

I prefer the way the other one in my initial post looks where as you drill down, it creates the  groupings while displaying the higher up ones in their perspective groups as well. Its less clunky and easier to interpret.