Forum Discussion
Continuous x-axis issue
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,
tjd is quite right. Your data in column “Period” is non-continuous. You can reference this post here: https://community.powerbi.com/t5/Desktop/what-do-the-continuous-and-categorical-type-options-on-the-x/td-p/67215
You can also reference this example here. The column “No.” is continuous.
Best Regards!
Dale