Display multiple years of Fiscal Periods in Sequence

[eburg]

Hello, Looking for guidance on how to use a line chart to display multiple years worth of data broken up by fiscal period. For example 13 periods in a year. 3 years worth of data. This is simple daily sales data, multiple UPCs per day in a table like any example you might see. So the tables are connection by the "FiscalDate" you see below. If I try to to display the line chart by "FiscalPeriod" it aggregates Period 1 from 2017, 2018, 2019 instead of displaying Period 1 2017, Period 2 2017, etc in order/sequence. 

I think there's a simple solution I'm just not grasping. Thanks for any help.  

[AllisonKennedy · Accepted solution]

@eburg  You will need to create a fiscal heirarchy - put Fiscal Year, then Fiscal Period into the line chart axis and drill down expanding all values. 

You can also turn the x-axis concatenate labels field to 'off' to make it grouped a bit nicer.