Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

best Visualization to display different goals and status

Hi everyone!

 

I need your knowledge to choose the most appropriate Visual to display a situation that can be summarize in the following table:

 

GoalGoal_ValueActual_Status
production time109
percentage of processing waste1512
Customer contact Time55
percentage of deliveriy on-time9593

 

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 

IntelligentM_0-1655125098861.png

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!

1 ACCEPTED SOLUTION
v-kkf-msft
Community Support
Community Support

Hi @Anonymous ,

 

I think the Bullet Chart visual is more appropriate, it can automatically resize the axes.

 

vkkfmsft_0-1655434290360.png

 

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.

View solution in original post

1 REPLY 1
v-kkf-msft
Community Support
Community Support

Hi @Anonymous ,

 

I think the Bullet Chart visual is more appropriate, it can automatically resize the axes.

 

vkkfmsft_0-1655434290360.png

 

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.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.