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

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

kpad — Tue, 02 Nov 2021 18:21:14 GMT

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!

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

v-yalanwu-msft — Fri, 05 Nov 2021 07:52:29 GMT

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

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.

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

kpad — Fri, 05 Nov 2021 16:01:49 GMT

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!