Forum Discussion
Plotting 2 data sets on a timeline
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 PlaylistHi 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.
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.