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 everyone!
I need your knowledge to choose the most appropriate Visual to display a situation that can be summarize in the following table:
Goal | Goal_Value | Actual_Status |
production time | 10 | 9 |
percentage of processing waste | 15 | 12 |
Customer contact Time | 5 | 5 |
percentage of deliveriy on-time | 95 | 93 |
in the column "goal_value" I have different types of measures: times and percentages. (for example first row is 10 days, second row is 15%, third row is 5 days, last row 95%).
I have only this data and I cannot change the structure on my db. I can only work in power BI.
My need is to create a visual that summarizes all the goals, the "goal_value" as a top limit and my actual value to see if i'm getting close to the goal or not.
actually i've already used the Radar visual, like below
but is not intuitive because I have big numbers (percentages) and amall numbers (days) in the same graph.
Do you have any Idea?
thank you a lot!
Solved! Go to Solution.
Hi @Anonymous ,
I think the Bullet Chart visual is more appropriate, it can automatically resize the axes.
Referencing: Actual Vs. Budget: Which visualization is most effective?
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
I think the Bullet Chart visual is more appropriate, it can automatically resize the axes.
Referencing: Actual Vs. Budget: Which visualization is most effective?
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
88 | |
85 | |
68 | |
67 | |
64 |
User | Count |
---|---|
209 | |
118 | |
116 | |
81 | |
74 |