Need help building continuous daily line chart

[Anonymous]

I am trying to build a continuous X axis for custom columns based on dates.

But I cannot, it doesn't let me switch to continuous.

Now I did see this solution, but as you see I did create and connect a separate table for dates which covers all dates in data table. And still I cannot change it to continuous X axis.

My end goal is to build a line chart for daily trend with around 1-3 month time horizon.

[Anonymous]

@Anonymous  - If you can't do continuous, it's probably because the data type is text. You can change the data type to date:

1. Click the date column.
2. Click the Modelling tab.
3. Select the date datatype.

I hope this helps. If it does, please Mark as a solution.
I also appreciate Kudos.

[Anonymous]

Thank you for hint.

Probably this won't work well for me, as if I change it to date format it defeats the purpose of my formula to make day-month format and pull appropriate data. 

The way Power BI behaves when you use dates it takes absolutely all data for required category ignoring actual dates. For example ,if you use month ; day axis it will take all data for month regardless the year and will not show day. This is exactly the reason I use custom columns.

[Anonymous · Accepted solution]

@Anonymous  - I think you would benefit from a Date Dimension table. Please see attached for an example and try the following:

1. Add your data to the attached file
2. Create a relationship between the 2 tables
3. Create your line chart with the Date column from the Date table on the X Axis.

I hope this helps. If it does, please Mark as a solution.
I also appreciate Kudos.