Forum Discussion
Helper IVKPI TARGET IS A MEASURE * FACTOR DOES NOT WORK
Hello,
I have a measure FY24sales total = calculate(sum(sales), year="2024"), say $100
Another measure FY25sales total=calculate(sum(sales), year="202"), say $150
3rd measure target = FY24sales total*1.1,
when i create a kpi, my target does not work, it shows as 0,
but if i manually create a measure target = $110, it will work.
Can someone explain why?
Many thanks
Zoey
Hi zraopingm ,
A KPI visual requires a base measure that evaluates to a value, a target measure or value, and a threshold or goal.
If you don't think this is the visual object you want, you can try using card.
Key Performance Indicator (KPI) visuals - Power BI | Microsoft Learn
If I have misunderstood your meaning, please provide more details.
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
7 Replies
Hi some_bih ,
Thanks for your quick response.
Hi zraopingm ,
I have created a simple sample, please refer to my pbix file to see if it helps you.
It works well, please make sure you put the year field in the trend axis.
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
zraopingmhi Rongtie,
thank you for taking the extra steps! this means a lot.
If i used the date table field say "year" into the tread axis, it works.. but if i used the time from the trans table where the sum of data resides in, it wont work.. is this normal?
In other words, do we have to use date table fields for KPI?
Zoey
Hi zraopingm ,
A KPI visual requires a base measure that evaluates to a value, a target measure or value, and a threshold or goal.
If you don't think this is the visual object you want, you can try using card.
Key Performance Indicator (KPI) visuals - Power BI | Microsoft Learn
If I have misunderstood your meaning, please provide more details.
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- zraopingm
SORRY that is my typo when i posted the help message, it shouled be "2025"
the measure works fine.
let me repost my needed help below:
I have a measure FY24sales total = calculate(sum(sales), year="2024"), say $100
Another measure FY25sales total=calculate(sum(sales), year="2025"), say $150
3rd measure target = FY24sales total*1.1,
when i create a kpi, my target does not work, it shows as 0,
but if i manually create a measure target = $110, it will work.
Can someone explain why?
Many thanks
Zoey
