Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello,
I've had a Power BI Report that I've been using for about a year without issue and for some reason it is no longer filtering correctly on the KPI cards and I can't for the life of me figure out why!
Example:
Measure for the calculation of the % of cases resolved in 1 day:
KPI_Pct_CasesResolved1Day =
VAR TotalCases = COUNTROWS('Cases')
VAR CasesAge1OrLess = CALCULATE(COUNTROWS('Cases'), 'Cases'[Case Age] <= 1)
VAR Percentage = DIVIDE(CasesAge1OrLess, TotalCases, 0) * 100
RETURN
IF(ISBLANK(Percentage), 0, Percentage)
Measure for the KPI Card's goal:
KPI_TTR_1 - L3 = 50
I then display that KPI card three times and fitler the card by Resolved Date with Relative date ranges of 30, 60 and 90 days. This has always worked just fine until recently, and the only thing that I changed recently was the Target measure from 25 to 50.
I can influence the card with the relative date filter, but the values are only updated when the relative date is recent - i can filter the card up to a relative date range of "In the last 25 Days" but anything higher than that and the values do not update.
There are no other filters in place on the visual or page.
This is affecting all of my KPI cards, not just this measure and I'm worried that I'll have to move to Cards with conditional formatting which would be a lot of effort as the report is around 50 pages with around around 500 KPI cards in use across the whole thing...
Is this a known issue? I've struggled to find anything to explain it!
Edit: I should mention that I tried brand new measures and a completely different dataset and found the same behaviour to occur there.
Solved! Go to Solution.
My problem seems to relate to the trend axis and I found a random and very different forum post where another user ended up using a date field from an unrelated data source in the trend axis, that seems to have worked for me!
My problem seems to relate to the trend axis and I found a random and very different forum post where another user ended up using a date field from an unrelated data source in the trend axis, that seems to have worked for me!
Some other variants of measures that do the same thing on KPI cards... To me it feels like a bug since these were all working and broke at the same time
KPI_Pct_CasesResolved10Days =
VAR TotalCases = COUNTROWS('CS.Case')
VAR CasesAge1OrLess = CALCULATE(COUNTROWS('Cases'), 'Cases'[Case Age] <= 10)
RETURN
DIVIDE(CasesAge1OrLess, TotalCases, 0) * 100
KPI_Avg_CSAT =
VAR AvgNPS = AVERAGE('Cases'[Survey Response.Score])
RETURN
IF(ISBLANK(AvgNPS), 0, AvgNPS)
Hi
Thanks for coming back to me and sorry a bit slow - been a day!!
No change at all, completely the same behaviour
@InsightScribe Hi!
Try with:
KPI_Pct_CasesResolved1Day =
VAR TotalCases = COUNTROWS('Cases')
VAR CasesAge1OrLess = CALCULATE(COUNTROWS('Cases'), 'Cases'[Case Age] <= 1)
VAR Percentage = DIVIDE(CasesAge1OrLess, TotalCases, 0) * 100
RETURN
IF(TotalCases = 0, BLANK(), Percentage)
is there any change in your output?
BBF
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
10 | |
10 | |
9 | |
7 |
User | Count |
---|---|
17 | |
12 | |
11 | |
11 | |
11 |