Gauge with different Values in different categories -Dynamic

[Anonymous]

What I like to visualize

company XYZ WON 24 Opportunities with total revenue of 2mill so far this year for ACCOUNT Gummibears

company XYZ has 68 Opportunities open with total value of 12 mill that is closing this year for ACCOUNT Gummibears

the Target for ACCOUNT Gummibears is set for 25 MIL this year

I tried gauges, created a table called Target, and put in the value -then put that the Gauge Field for the target. So that works. I'm struggling to display the attached gauge value. Help?

[v-easonf-msft · Accepted solution]

Hi , @Anonymous 

Try to create a new measure to calculate this value  then apply it to a new card visual.

Adjust the background transparency and position of this card visual, and then combine this visual and  the original gauge visual into a group.

Best Regards,
Community Support Team _ Eason

[lbendlin]

That's not what a gauge is for.  Use a regular column or bar chart, or a custom visual with a 180 degree pie chart.