Forum Discussion

MHenrik's avatar
MHenrik
New Member
5 years ago

Need help with KPI visualization

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,

 

 

1 Reply

  • littlemojopuppy's avatar
    littlemojopuppy
    Icon for Community Champion rankCommunity Champion

    Someone can only speculate why without knowing the measures you're using for sales and budget