Forum Discussion

PaulCo's avatar
PaulCo
Helper II
8 years ago
Solved

Line Chart X-Axis Date Formatting

I am having issues setting up the format of the dates on my axis of a chart.

 

I am using the following date table:

 

DateMonthMonth NameFiscal YearFiscal QuarterPeriod
10/1/201410OctoberFY15Q1FY15 Q1
10/2/201410OctoberFY15Q1FY15 Q1
10/3/201410OctoberFY15Q1FY15 Q1
10/4/201410OctoberFY15Q1FY15 Q1

 

 

However, When I put the Period and the Month into the Axis field, the months are in alphabetical order...

 

If I pull in the month field as well then it gives me the format that I need but i don't want to show the month number as it could be confused as the day of the month, I only want to show the Period and the Month Name.

 

 

Is this possible? either by amending the date table or by changing how the fields are setup?

 

Need Help

2 Replies

    • PaulCo's avatar
      PaulCo
      Helper II
      8 years ago

      Thanks

       

      I got an error message when I tried to sort by date but it worked when I sorted by 'Month'.