Forum Discussion
KPI MTM Change Goals
Hi! I'm hoping for a little bit of help with something that has confounded me...
I have a dashboard that presents inventory balances and MTM change due to pricing and volume as well as total MTM change for inventory as a whole.
I'm presenting using the KPI visualization. My goal is to present any increase is bad and any decrease is good. Best to explain this in two parts...
With total inventory on order (the left most KPI) it works exactly as expected...indicator is current month balance, target is last month balance. And I'm using the same current/last month logic with the remaining three but the logic isn't correct. Look at MTM volume change...it's negative despite declining by $121.4M (because the previous month it declined a whole lot more).
I've tried creating a measure where [Change Goal = 0] but that results in this...
Can anyone suggest how to make the KPI indicator to show "good" if any decline and "bad" if any increase?
Ok! So I figured this out. But I don't completely understand why this solution worked. If anyone would like to offer an explanation, I'd love to understand why.
Solution:
- Created a column called Change Goal set to a constant = 0
- Created a measure called Inventory Change Goal = SUM([Change Goal])
- Used the measure Inventory Change Goal as the Target in the KPI visualization.
And the expected results were achieved...compare this screen snip to the one at the very beginning of the thread.
Can anyone explain why? It seems unnecessary to have to add a field to 60M records of data to achieve something so simple (not to mention wasted RAM). Thank you!
6 Replies
hi, littlemojopuppy
I'm a little confused by your description. Do you want to show "Good" or "Bad" in the KPI visual?
and what is your expected output.
Sample data and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490Best Regards,
Lin
Right now, the "good" and "bad" is determined relative to the previous month, which is why MTM volume change is shown as bad (because while it declined, it didn't decline as much as the previous month).
Goal is ANY decline is good, and ANY increase is bad. If anyone could provide an idea how to make this happen I'd appreciate it!
hi, littlemojopuppy
Could you share some sample data or a simple sample pbix file and your expected output?
That will be a great help.
Best Regards,
Lin
