Forum Discussion
How to maintain KPI Target in Power BI
Hi, I started with Power BI last year so my target table has only 1 year of target data for each country as shown below. This year I need to add target data for year 2023. Same as year 2022, it ...
Anonymous,
You can add a date column to the Target table and create a relationship to the calendar table using the date column. This date column will contain the first day of the year:
2022 --> 2022-01-01
2023 --> 2023-01-01
I have done that initially but the target value in the card visual for comparison went blank when the selected year in the slicer is 2022 and the year to date month is Dec.
DataInsights
Super User
Super UserAnonymous,
Does your date slicer use Year from the Calendar table? Can you provide an example pbix using OneDrive, etc.? Also attach a screenshot of the expected result.