Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 will be one yearly average value per country with no breakdown by month as the target is the same for every month. I have a calendar table and plan to add a slicer for year selection in every page of the visuals so that I can see the actual vs target for each selected year.
In order to link the Target table to my calendar, do I have to add a "Date" column to the Target table and replicate the value for the 12 months of each year? Is there a quicker or better option (using DAX measure) to retrieve the selected year target value for comparison with actuals?
Solved! Go to Solution.
@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
Proud to be a Super User!
I managed to make the solution suggested by DataInsights work for my card visual by adding ALLEXCEPT to the calculate measure used in the visual which is as follows:
@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
Proud to be a Super User!
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.
@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.
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
64 | |
63 |
User | Count |
---|---|
140 | |
105 | |
102 | |
81 | |
67 |