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

“

(peppy music) - [Instructor] So which methods did you uncover? The first thing we wanted to do was show a constant line of 1 million on our column chart. And there are two easy ways to do that. One is to use the analytics panel, which is on the right under your visualizations pane, and add a constant line of a million. And I'm going to make it orange just to make it stand out. And there you could make it dashed or semi-transparent and apply different styles to it. So that's the easiest fix for adding a constant line. And notice here that you could have added trend lines and slightly more complicated things as well. Now let's just delete that and show you an alternative. Another way of doing it is to create a measure of target profit. So here we would go new measure and say, target profit equals a million. Now most people don't think of that with a measure because measures typically are like simple formula in Excel…

Contents