Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I'm new to Power BI and experiencing a problem with my KPI charts.
As per the example below, no revenue is displaying within the KPI. I'm expecting it to show the results within the table which are correct. If I remove the target the revenue appears correctly as £153k. As soon as I add the cumaltaive target as the target goal the revenue disappears. Also it is showing the annnual cumulative budget and not that for the current month £186k.
Just to clarify, the figures I am looking for are :
£153k cumulative YTD
£186k cumulative YTD target
% difference
Any assistance greatly appreciated.
Dave
Solved! Go to Solution.
Hi @dave_dingle
When you add the cumulative target as the goal, it displays December’s cumulative budget value according to the current context, and the cumulative revenue is blank in December, so it presents the result you don’t want. I create a new measure to express the cumulative budget based on the old budget measure and the revenue measure. The new one will calculate result as blank if its related revenue value is blank in the same month. Then I use the new budget measure to replace the old one in KPI visual. You will see the measure and the difference below.
new Budget YTD = IF(NOT(ISBLANK([cumulative Revenue YTD])),’Budget’[Budget YTD],BLANK())
I use dummy data in my table. This may not be the best solution but it seems achieve what you need. Have a try!
Best Regards,
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.
Hi @dave_dingle
When you add the cumulative target as the goal, it displays December’s cumulative budget value according to the current context, and the cumulative revenue is blank in December, so it presents the result you don’t want. I create a new measure to express the cumulative budget based on the old budget measure and the revenue measure. The new one will calculate result as blank if its related revenue value is blank in the same month. Then I use the new budget measure to replace the old one in KPI visual. You will see the measure and the difference below.
new Budget YTD = IF(NOT(ISBLANK([cumulative Revenue YTD])),’Budget’[Budget YTD],BLANK())
I use dummy data in my table. This may not be the best solution but it seems achieve what you need. Have a try!
Best Regards,
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.
Thank you @v-jingzhang, for your simple and clear explanation, your solution worked exactly as required.
I appreciate you taking the time out to respond.
@dave_dingle Are you looking to create below visual. I have used dummy data as your data was not in text form.
I have created YTD Budget and YTD Revenue measures using Quick measure window as below
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |