Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Visualization: YTD target vs YTD actual

I've got a table with dates and sales, it's connected to CRM online which will be auto refreshed.   i've created a "Gauge" dashboard with Max (Year Target) and Target (YTD Target)   t...
Need Help
Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
9 years ago
Anonymous wrote:

1) I have to update the YTD target "98" manually.  is there any way get this update automaticlly? 

2) can i change the font of target '98", it look too small.  When i change txt size under "Data labels", the target "98" stay the same. 

 

1) Create a MEASURE NOT A COLUMN and as per GilbertQ's suggestion use TOTALYTD OR DATESYTD

YTD Measure FY 06-30 =
TOTALYTD ( SUM ( Table[Column] ), 'Calendar'[Date], "06/30" )

YTD Measure FY 06-30 ALT =
CALCULATE ( SUM ( Table[Column] ), DATESYTD ( 'Calendar'[Date], "06-30" ) )

you can skip the optional Fiscal Year End (the underlined part) if you use a regular calendar year!

then place that MEASURE in the Target Value field => that's in the Fields not under the Formatting (Paint Brush)

get rid of all numbers you've put in the Gauge Axis under the Formatting (Paint Brush) options

 

2) to change the size of the font of the target you'll have to use the Tachometer instead of the regular gauge

because unfortunately this option is not available in the gauge

Look at my response and picture here

http://community.powerbi.com/t5/Desktop/visuals-Gauge/m-p/121521#M51372

 

Hope this helps!

Good Luck! :smileyhappy: