Forum Discussion
Need help building continuous daily line chart
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.
Anonymous - If you can't do continuous, it's probably because the data type is text. You can change the data type to date:
- Click the date column.
- Click the Modelling tab.
- Select the date datatype.
I also appreciate Kudos.
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.