Forum Discussion
Creating two timelines, comparing actual versus forecasted
Hi all I have a set of data with cash balances per day I am looking to have two graphs (or one overlapping if possible) with the following: 1. Showing actual balances for a period specifi...
Hi amitchandak
Thank you for the help.
I added the measure and created an independent date table, however I am still missing one step i believe.
Data below:
Date1 = ADDCOLUMNS (CALENDAR(date(2022,01,01), date(2022,06,30))
,"Month Year", Format ([date], "MMM-YYYY")
,"Month Year sort", FORMAT([date], "YYYYMM")
,"Year", YEAR([Date])
, "Qtr Year", FORMAT([date],"YYYY/QQ")
)
Table called "Table"
with "Date" and "Balance" columns typed in
Two tables are linked as follows:
When adding a forecasted line graph:
X-Axis is Date1.[Date]
Y-Axis is Table.[Balance]
However, when moving the slicer, the peirods remain the same for the forecast and the actual
Is there a way to create one slicer
Thank you!