Forum Discussion
Plotting 2 data sets on a timeline
- 1 year ago
Vengiro you need a separate date dimension that will have relationships between both the tables and then you will use that on the x-axis to plot the values from both the actual and plan tables.
As a best practice, add a date dimension in your model and use it for time intelligence calculations. Once the date dimension is added, mark it as a date table on table tools. Check the related videos on my YT channel
Add Date Dimension
Importance of Date Dimension
Mark date dimension as a date table - why and how?
Time Intelligence Playlist - 1 year ago
Hi Vengiro
By the looks of it, you're not using separate dates/calendar table and instead creating a relationship directly betwen the two tables. The dates/calendar table must contain a column with unique dates that encompasses all dates in your fact tables. Create a one to many relationship from that table to your fact tables and use the date dimensions from the calendar instead in your visual.
Vengiro you need a separate date dimension that will have relationships between both the tables and then you will use that on the x-axis to plot the values from both the actual and plan tables.
As a best practice, add a date dimension in your model and use it for time intelligence calculations. Once the date dimension is added, mark it as a date table on table tools. Check the related videos on my YT channel
Add Date Dimension
Importance of Date Dimension
Mark date dimension as a date table - why and how?
Time Intelligence Playlist