Forum Discussion
Helper IVKPI Card isn't filtering
Hello! I have a KPI visual on my report that has my target and actual percentage. But it's only pulling in the most recent month and not taking the average of the months in the slicer.
How do I modify that?
ex) August date = 94.1%
But when I open the data to May - August, it doesn't modify
7 Replies
- parry2k
Super User
nataliesmiy1357 can you hover over the filter icon on the card visual and see if the filter is getting applied to it?
nataliesmiy1357Yes - the filters are being applied:
- parry2k
nataliesmiy1357 if it is on or after Jan, 1 2021 why the table is not showing the data after May (2nd image), what is the filter on the table visual? Seems like one visual is filtered on different dates (mainly table)
- nataliesmiy1357
So sorry! This is the filter with the date range May1 -today:
- parry2k
nataliesmiy1357 you really need to check at your end, what filters are applied on both KPI card and table, it is confusing. If there are different date filters then the expected output could be different.
- nataliesmiy1357
I reset the filters.
This is the data with the date filter = August 2024 only. It is correct.
But when I add in the date filter: July 1, 2024 - August 31, 2024, the numbers get off. The 95.6% in the KPI tab SHOULD be 94.9 (average of the line result) and the Target value SHOULD be 95.8 instead of 96.
- parry2k
nataliesmiy1357 It will be easier if you share pbix file using one drive/google drive with the expected output. Remove any sensitive information before sharing.
