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
v-caliao-msft's avatar
v-caliao-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Anonymous,

 

For the first question, you can drag a field to "Target value", so when the value in the filed changed, then the target in your gauge will be changed automatically.

For the second question, I have tested it on the latest version of Desktop (Version: 2.42.4611.701 64-bit (January 2017)). There is no an option for use to change target value font. If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.
https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

Regards,

Charlie Liao

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    v-caliao-msft if the target table is like below, what's the DAX to get YTD target and TODAY's target.  For example, if today 30/01/2017. i would like YTD = 22+22+22+0+0+0+0=66,  and TODAY's target = 0.

     

    thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      any1 know? thanks. 

    • GilbertQ's avatar
      GilbertQ
      Icon for Super User rankSuper User
      9 years ago

      Hi Anonymous, you could use the TOTALYTD and then as the code below is shown, it will complete the YTD until the 30 June, if you want it until December you can either change it to be "12/31" or remove it.

       

      TOTALYTD([Sales],'Date'[Calendar Date],ALL('Date'[Calendar Date]),"6/30")

      NOTE: For the above you do require a Date table. In which you can implement this into your model with this blog post: Power BI – How to Easily Create Dynamic Date Table/Dimension with Fiscal Attributes using Power Query

       

      And then you can get Todays Target based on a Calculated Measure.

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        GilbertQ thanks, is there any way to replace 30/06 to "today", so i don't need to update this everyday?