Sort by 24-Hour, label by 12-Hour

[foxb3692]

Greetings,

I have a Line and Stacked Column Chart visual that is oh so close to what the user wants, but not quite.

The desired X-Axis Sort is Ascending 24-Hour Time, but the desired X-Axis labels are 12-Hour AM/PM time. 

I have a TimeDimension query with both an "Hour" field, formatted with leading Zero, and a calculated column 

Hour AM/PM = FORMAT(TimeDimFall[Time],"H AM/PM").

Using "Hour" as the X-Axis produces the correct sort:

The user doesn't want to see hour "13", they want to see the label "1 PM"

Using Hour AM/PM in the visual lists "1 AM" first then "1 PM" next:

 

How do I get the correct sort with the desired X-Axis labels?

[MattAllington · Accepted solution]

Add the label column to the axis. Click on the label column in the fields list and select "sort by column" and use the 24 hour column for sorting. 

[foxb3692]

Brilliant! I had to walk through the steps a couple of times, but I got it.

Thank you @MattAllington !