Forum Discussion
Solved
Continuous x-axis issue
I have a problem when using dates in the X-Axis when the type is Continuous. Our period data is stored as the last day of each month and when I put the period in the X-Axis, the axis doesn't line...
In order to properly show dates as "continuous" data, you need to be using dates from a date table, not your non-continuous fact table (that's categorical and why it is showing correctly as categorical). After building the data table, you link your fact table dates to the date column in your date table. The x-axis would then be from the date (or month, or year, etc.) column in the date table, not from your fact table.
Hi,
Could you tell me if your problem is solved? You can mark the right answer to help others if it's convenient for you.
Best Regards!
Dale