Forum Discussion
Measure changing based on Visualization
This has worked for the past year but now, in the new year, it is broke. In the image I provided, I have a KPI visualization where "Operating Income FC-1" is the "Indicator". As the "Indicator", it displays a total of $1,138,473 (which is incorrect)
When I just pull the same measure out on the page as a "Card" visualization, the total is $467,794 (which is correct)
So, the short story, I drag the measure and put it in KPI, it's wrong. I grab the same measure and just drop it on the page, it's right. This same set-up worked correctly on Dec 31, 2017, is working incorrectly on Jan 4, 2018.
Yes move it to google drive and share from there. Make sure to remove any sensitive information your dataset have.
Cheers,
P
7 Replies
KPI shows based on what column you have on trend axis, if you have year on trend axis, it is showing the value of most recent year, check see data on this KPI and tht will give you the answer.
Yes it was working in 2017 because you have only one year. Basically it is showing you what ever the most recent year is there because you have year on trend axis. In last year because 2017 was the only year you think you were getting correct data.
To test, change month on trend axis and it will show the value of most recent month in KPI.
Hi,
Share the link from where i can download your file.
Yes move it to google drive and share from there. Make sure to remove any sensitive information your dataset have.
Cheers,
P
