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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
kpad
Regular Visitor

Adding a % to value as a displayed value in bar/line chart

We are using the bar/line chart to show actuals to goal. We want to also display % to goal. We have the calculated field and would like to display it directly in the visualization, not just as a tooltip. Is this possible? We found the Zebra add-on, but the lack of freedom of customization isn't working for us.

 

Thank you in advance!

kpad_0-1635877047997.png

 

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

Hi, @kpad ;

Do you mean %=actual value/ goal value , if so, you could create a measure to calculate the percentage then put it into line feild:

Measure = SUM([value])/SUM([goal])

then 

vyalanwumsft_0-1636098667184.png
Or you could try Bullet chart 2.2.0 viusal.

Best Regards,
Community Support Team_ Yalan Wu
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

2 REPLIES 2
v-yalanwu-msft
Community Support
Community Support

Hi, @kpad ;

Do you mean %=actual value/ goal value , if so, you could create a measure to calculate the percentage then put it into line feild:

Measure = SUM([value])/SUM([goal])

then 

vyalanwumsft_0-1636098667184.png
Or you could try Bullet chart 2.2.0 viusal.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

We ended up going with that bar/line chart combo! I didn't realize we could add multiple lines AND bar chart categories.

 

The Bullet Chart visual is also news to me and an interesting option.

 

This is great, thank you!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.