Individual sales targets vs actual in Power BI

[jakeryan56]

Hi, I currently have some detailed reporting in PowerBI on sales performance for individual staff with a lot of different measures set-up. However, one of my clients needs to have individual sales targets vs actual in PowerBI as he currently tracks this in a spreadsheet and would like to move away from this.

I am assuming I could create a weekly/monthly target table that the data could pull from but I am not too sure where to start as this element adds a lot of complication. Some guidance would be appreciated!

This is similar to what is being used at the moment:

[v-huizhn-msft]

Hi @jakeryan56,

Without your sample table, it's really hard to post detailed solution. You'd better share more details, sample table and list expected result, so that we can help you dedicatedly. Do hide information before you upload your data.

Best Regards,
Angelia

[Greg_Deckler]

Not entirely sure, but perhaps just use an Enter Data query to enter your goals?