Goals and Targets in Power BI

2 Comments

In Power BI, a common requirement is to display progress towards meeting a goal. For example, if you want to track monthly progress of salespeople vs their targets.

To do this, first create a new Power BI report. In our example, we have 2 tables:

  • Goals – which holds the targets for each salesperson
  • Sales – which holds sales transaction records

We will keep this simple and not use dates. The tables have the following data. Each salesperson has different goals:

We will now add a relationship between the 2 tables:

Now, if we add Salesperson and Amount to a column chart, we can see each Salesperson’s total amount. However, this does not show us how they are doing against their goal:

If we add the Goal field and set it to display the Min value, this displays our goals for each salesperson alongside their current progress:

Which we can then rename to Goal:

If we wanted to see how they are progressing as a percentage we can change this to a 100% Stacked Column chart:

Renamed:

Note this example does not deal with dates, which I will cover in another post.

 

THANKS FOR READING. BEFORE YOU LEAVE, I NEED YOUR HELP.
 

I AM SPENDING MORE TIME THESE DAYS CREATING YOUTUBE VIDEOS TO HELP PEOPLE LEARN THE MICROSOFT POWER PLATFORM.

IF YOU WOULD LIKE TO SEE HOW I BUILD APPS, OR FIND SOMETHING USEFUL READING MY BLOG, I WOULD REALLY APPRECIATE YOU SUBSCRIBING TO MY YOUTUBE CHANNEL.

THANK YOU, AND LET'S KEEP LEARNING TOGETHER.

CARL

https://www.youtube.com/carldesouza

 

ABOUT CARL DE SOUZA

Carl de Souza is a developer and architect focusing on Microsoft Dynamics 365, Power BI, Azure, and AI.

carldesouza.comLinkedIn Twitter | YouTube

 

2 Responses to Goals and Targets in Power BI

Leave a Reply

Your email address will not be published. Required fields are marked *