Forum Discussion
KPI visual showing incorrect data
I'm trying to get the KPI visual to display the correct values. Can anyone help? screenshot attached. The table seems correct, but when I use the KPI visual the data doesn't display properly.
Anonymous filter your kpi to current date, reason is that you have dates in the future and then it shows all the dates in the KPI and picks up the last date which probably doesn't have the data, filter it on or before today and that will do it.
✨ Follow us on LinkedIn and to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
3 Replies
Anonymous glad you have the solution. Do subscribe to my YouTube channel (link below) I will be sharing some interesting Power BI related contents. Cheers!!
✨ Follow us on LinkedIn and to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
Anonymous filter your kpi to current date, reason is that you have dates in the future and then it shows all the dates in the KPI and picks up the last date which probably doesn't have the data, filter it on or before today and that will do it.
✨ Follow us on LinkedIn and to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
Thank you parry2k ! 😊