Forum Discussion
Actual vs Target
Dear Community, I am currently modeling a report that needs me to prepare a graphic or a KPI card that would indicate actual values vs target values. Actual values are reported with individual d...
Hi,
I recommend creating a calendar table either in Power Query or Power BI using DAX. Once you have your calendar table ( a Year column/ a Month column/ a date column) , link it to your order table for both actual and target data.
After setting up the calendar table, you can create a yearly slicer to display your actual and target data by year.
Hope this helps!