Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Could someone please point me in the right direction on this. I have selected 3 distinct values whish are Total Utilization, Approved budget and anticipated final. How can I calculate the collout gauge value as a percentage of total utilization?
Solved! Go to Solution.
Ok, how about creating a new measure based on the two you already have:
PercMeasure= DIVIDE([Total utilisation YTD], [Approved Budget])
and set it in values of the gauge. Then set the max of the gauge to 1 and min to 0
Just add SUM.
https://community.powerbi.com/t5/Desktop/Vizualization-Card/m-p/404713#M185160
Hi,
Sorry, it's callout value in correct. I actually want the gauge to show percentage of Total budget utilization vs approved budget because beside the gauge visual has Card visual to show the budget spending in unit value.
Hope this will get you to my point.
Thanks
Ok, how about creating a new measure based on the two you already have:
PercMeasure= DIVIDE([Total utilisation YTD], [Approved Budget])
and set it in values of the gauge. Then set the max of the gauge to 1 and min to 0
Hi,
i'm trying to create the measure, but it says that the table that i selected cannot be determined. Why is it?
Just add SUM.
https://community.powerbi.com/t5/Desktop/Vizualization-Card/m-p/404713#M185160