Forum Discussion
KPI visual not showing data while Card does
I have a Sales table and a Calendar table with dates, and a relationship between them.
In the Sales table I have two measures that I am trying to place in a KPI visual:
- CurrentMonthAverage, for this months average sales cycle
- LastYearAverage, for same calculation in same period last year
I want to compare the two in a KPI visual.
The measures work well in independent Card visuals, and I have used simple filtering to verify the accuracy of the LastYearAverage measure. The issue arises when I try to put the measures as Value & Target in the KPI visual, with the Calendar as the Trend Axis. Even if I try only CurrentMonthAverage as Value and Calendar in Trend Axis all I see is 0.0 on the KPI, when there should be a value there, but I can clearly see lines behind that zero.
Here is how the visual looks like if I limit it to Current Month, using the same Calendar table as in Trend axis:
And here is it without the Calendar filter to limit it to current month:
Clearly there is data in the background, so I am not sure why both are showing as 0, given that the same visual, when converted to a Card using the same measures, will show values in both cases?
Update: If I try using the LastYearAverage it actually shows data, but it's the wrong number. It's almost as if it's pulling dates in from somewhere else but there are no visible filters beyond what I have set.
Replying to my own message in case anyone else get the same problem:
I had to use Date Hierarchy instead of just the regular Date from the Calendar table. And since that was marked as a Date Table, I first had to create the Hierarchy. But this solved the issue.
2 Replies
Replying to my own message in case anyone else get the same problem:
I had to use Date Hierarchy instead of just the regular Date from the Calendar table. And since that was marked as a Date Table, I first had to create the Hierarchy. But this solved the issue.
