Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
This is my first time asking a question in Power BI community!
I am wanting to use the gauge in Power BI to illustrate if a project (either total spend or spend by category) is going over its budget.
The screenshot lists the sample data I am using and an image of the gauge.
The total budget is $17,500 and $18,700 is being spent - this is an overspend of $1,200.
Can anyone suggest how I can get the gauge to work as intended with the sample data please? Are there any good videos on YouTube or elsewhere that someone could suggest which would help me achieve this please?
Thank you!
Solved! Go to Solution.
Hello @joshgirlebennet ,
You can adjust it as you want in the formatting option, they put it randomly based on your data
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
Proud to be a Super User! | |
Hi @Idrissshatila thank you for your suggestion. When trying this method, the cost is still doubling (screenshot below):
When putting the sum of est cost into the maximum value, it totals correctly however is still not quite what I am trying to achieve:
Hello @joshgirlebennet ,
You can adjust it as you want in the formatting option, they put it randomly based on your data
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
Proud to be a Super User! | |
Hello @joshgirlebennet ,
try to put the sum of est cost in the target value section.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
Proud to be a Super User! | |
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
85 | |
75 | |
69 | |
65 |
User | Count |
---|---|
214 | |
128 | |
117 | |
82 | |
76 |