Forum Discussion
visualize given forecast and last year values
Hi mueller_82,
You need to create a date column both in Forecast table and Last Year table. Then create a relationship between the date table with those two tables based on the date column. In Forecast table, create a column to return whether the row is to display in the line chart. Then use this column in Visual level filter pane to filter the line chart. For detail information, see attached .pbix file.
Best Regards,
Qiuyun Yu
Hi Phil_Seamark
thank you very much! I now used the univot feature to change the format of the forecast and the last year table as you suggested (Category, Month, Value for selled amount) .
Im really new in Power Bi and I don't know what the best strategy is to visualize the actual data (Jan 17 and Feb 17) and the forecast data (Mrz17-Dez17) in one line. What measure do I need? Is it better to create one table for that by adding the forecast table to the actual data table, even if the actual data table consists of more columns so that some would be blank?
Maybe there is a general procedure how to visualize actual data/forecastdata/Last year data correctly?
Thanks!! :)
Community SupportHi mueller_82,
You need to create a date column both in Forecast table and Last Year table. Then create a relationship between the date table with those two tables based on the date column. In Forecast table, create a column to return whether the row is to display in the line chart. Then use this column in Visual level filter pane to filter the line chart. For detail information, see attached .pbix file.
Best Regards,
Qiuyun Yu