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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

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.

CRM.PNG

 

i've created a "Gauge" dashboard with Max (Year Target) and Target (YTD Target)

CRM.PNG

 

this dashboard shows current at 87, with 98 YTD target and 7000 Year target. 

CRM.PNG

my problem is

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. 

 

 

11 REPLIES 11

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.