From the course: Power BI Challenges: 15 Skills-Building Analytics Exercises for Data Professionals

Unlock the full course today

Join today to access over 24,900 courses taught by industry experts.

Solution

Solution - Power BI Tutorial

From the course: Power BI Challenges: 15 Skills-Building Analytics Exercises for Data Professionals

Start my 1-month free trial Buy for my team

Solution

“

(bright music) - [Instructor] So how did you get on? The first part of the challenge was to change our trend column to a line chart comparing average percentage profit. So let's do that first. We're going to need to recreate our measure for average profit. Make sure we're in the right table. Say new measure, profit percent and it was the sum of both companies' profit divided by the sum of both companies' sales like so. I think that didn't work because profit percent already exists as a measure in a different table and normally it gives you an error message for that, which I was going to walk you through, but it didn't. So I've added a number two and that's why I've done that. So now we have a thing that we can show on our line chart to what will be a line chart. So at the moment, that is showing dollar profit, but we want to show profit percent. And let's just check if we come over here what sort of levels we're…

Contents