Forum Discussion
Need help building continuous daily line chart
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 - I think you would benefit from a Date Dimension table. Please see attached for an example and try the following:
- Add your data to the attached file
- Create a relationship between the 2 tables
- 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.
3 Replies
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 - I think you would benefit from a Date Dimension table. Please see attached for an example and try the following:
- Add your data to the attached file
- Create a relationship between the 2 tables
- 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.