Forum Discussion
Can't get chart to plot forecast
- 4 years ago
Hi benaford
I made several changes to your pbix. Please download the attachment at bottom to see details. Changes are:
1. Remove the old relationship between Sales and Forecast tables. Add a one-to-many relationship from Calendar to Forecast. The old relationship uses Sales table to filter Forecast, which caused the data missing as Sales table doesn't have data past week 22. Using Calendar table to filter Forecast can avoid this.
2. Add a Dim Item table to the model and create one-to-many relationships from it to both Sales and Forecast tables on Item Nbr or Item Name columns. Use DimItem's Item Name in the slicer on report.
3. Remove FISCAL YR from the visual. Then you will have the following visual as expected.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
benaford , Check your calendar table , it need to have future date