Forum Discussion
How to maintain KPI Target in Power BI
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
Super UserAnonymous,
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
Anonymous,
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.