Forum Discussion

ovetteabejuela's avatar
ovetteabejuela
Impactful Individual
9 years ago

Moving Target - How to Handle

Hi All,   I have a dummy PBIX file, where I'm trying to find out how to properly handle moving targets.   At the daily level it does properly show because it's not aggregated, but as soon as I ro...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi ovetteabejuela,

I can't download your .pbix file, could you please share your file in here, so I download and analysis further.


Best Regards,
Angelia

ovetteabejuela's avatar
ovetteabejuela
Impactful Individual
9 years ago

v-huizhn-msft, sorry I'm in a corporate network right now and OneDrive(Public) is being blocked, same reason why I published the PBIX file in Google Drive(not sure why IT did not block that one).

 

When I get home, 12 hours from now. I can share it in OneDrive although I did check and it seems that the link I just shared above is working just fine.

 

Thank you by the way for trying to look into this.

  • Dog's avatar
    Dog
    Responsive Resident
    9 years ago

    Hi ovetteabejuela

     

    looking at the data, the target sales is the same across all employees, departments and dates so I would imagine that Average is the best fit. just changing the aggregation from SUM to Average does appear to give the results in a much more meaningful manor. 

     

     

     

    is this not what you were looking for? 

    • ovetteabejuela's avatar
      ovetteabejuela
      Impactful Individual
      9 years ago

      Yes the target should be the same for everyone for a given time (start/end date).

      • Dog's avatar
        Dog
        Responsive Resident
        9 years ago

        Hi, 

         

        not entirely sure I follow, using average and drill up and down works best with a different graph as you don't have dates to use for the trend that a line graph works best with.