Forum Discussion
KPI Displaying incorrect Indicator
I suggest that you create a table visual beside your KPI, then drag all the attributes that you have in the KPI visual into the table visual. Then you should be able to see what is happening. The KPI visual can be set up in many different ways, sortet, etc.
Hope this helps.
Hi DebbieE,
If it is convenient, could you share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)
Best Regards,
Cherry
Its just Adventureworks linked from FactResellerSales and DimDate
I suggest that you create a table visual beside your KPI, then drag all the attributes that you have in the KPI visual into the table visual. Then you should be able to see what is happening. The KPI visual can be set up in many different ways, sortet, etc.
Hope this helps.
Perfect, the 7.0 Mill is a grouping of the Month of December because I have dragged month from Hierarchy.
So at least I understand the indicator
So the question is now, what Trend Axis do I use to get this working so I see the full total? Ig I use Year from the date hierarchy the indicator just says Blank. This is confusing as I would expect this to work in the same way as Month, All the years are aggregated and I get what I want for the KPI
If I drag in the actual date, again it just says blank.
If I try dragging in Calendar year , again it just says Blank
However, If I take the target out I can at least see the indicator. If I drag in YEar I can see the value for the last year rather than everything
As soon as I add a target in it just goes to blank. I So my question is why is the target changing the indicator to blank?
