From the course: Excel: Creating a Dashboard with Power Query (Microsoft 365)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Link Excel shapes to the data and linked picture trick

Link Excel shapes to the data and linked picture trick

From the course: Excel: Creating a Dashboard with Power Query (Microsoft 365)

Start my 1-month free trial

Link Excel shapes to the data and linked picture trick

“

- [Instructor] Now let's calculate the total sales value for the latest month and a previous one, and bring it to the dashboard here. I've drafted it to look something like this. I also want to calculate the percentage difference to previous month. Now to set this up, we're going to need the total sales value, we're also going to need our flag for the latest month and the previous month. So let's go and create another pivot table with this information. I'm just going to copy one of the existing pivot tables, paste it right here, and then adjust the fields as we need. From the all field here, let's bring in the total sales value. So I'm just going to place a check mark to push it to the values section here. I don't need the month name, so I'm just going to drag it and kick it out. I need the month flag, I'll bring that to the columns. This is the information that I need for the dashboard, latest and previous. I…

Contents