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 am facing an issue when setting up a KPI for the total sales. The indicator is the total sales, I use month as the trend axis and the budget as a target. When filtering using a between slicer for a date interval, the budget (target) shows the correct aggregated value for that specific range, however, the "total sales" value only shows the n:th month value. E.g when trying to display the KPI for the full year 1-12, the budget 59M is correct but only December's total sale is displayed. The same for the range 1-6 with the budget 29M, but sales for only June.
When filtering total sales with date ranges in other visualizations on the page it works fine but not the KPI....
Thanks,
Someone can only speculate why without knowing the measures you're using for sales and budget
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
35 | |
32 | |
18 | |
18 |