Watch videos with subtitles in your language, upload your videos, create your own subtitles! Click here to learn more on "how to Dotsub"

3-3a

0 (0 Likes / 0 Dislikes)
  • Embed Video

  • Embed normal player Copy to Clipboard
  • Embed a smaller player Copy to Clipboard
  • Advanced Embedding Options
  • Embed Video With Transcription

  • Embed with transcription beside video Copy to Clipboard
  • Embed with transcription below video Copy to Clipboard
  • Embed transcript

  • Embed transcript in:
    Copy to Clipboard
  • Invite a user to Dotsub
>> If you're tracking your data over time, typically, a line chart is going to be the best visualization to do this. The other thing that you can add to Power BI line charts is the trend lines that help understand the average trend in your data over time. So let's just take a look at our sales revenue by year. You can see, we've got this kind of wavy line but in the Formatting pane, you'll also see an option to turn on your Trend Line. When you do that you can see, okay, from start to finish, the average is actually trending down over time. If you expand this, you'll see a few different options for formatting it, change things like the Color and the Dashed Style. And also, if I've got multiple measures plotted on this chart, for example, if I take sales variance... I'll have an option in the Trend Line option to combine these trend lines. If I've got two measures, I might want to turn that off, and now I get a separate trend line for each of the different measures. So I've got one in the green one for the revenue, and one black one for our year-to-date sales. The other place you can put trend lines in is on a scatter chart. So for example, if I've got a scatter chart that's comparing my revenue and my units, let's look at this by our Product categories. I can see I've got, Urban category sold the most. But again, maybe I want to see what's the line of best fit across all of these different variables. And come in and turn the trend line on and I'll get that through the middle of those. Equally, if I was splitting this down by different manufacturers, I'd get the option again to combine or view those separately. So I can see each different trend line for each of the different categories in my data. So it's an easy way to add trend lines to your visuals to help get a better overview of the overall trends within your data.

Video Details

Duration: 1 minute and 59 seconds
Country: United States
Language: English
License: All rights reserved
Genre: None
Views: 19
Posted by: csintl on May 25, 2016

[email protected] ----- (Please provide translations for these languages: Chinese (Simplified) (chi_hans), Chinese (Traditional) (chi_hant), English (eng), French (France) (fre_fr), German (ger), Italian (ita), Japanese (jpn), Korean (kor), Portuguese (Brazil) (por_br), Russian (rus).)

Caption and Translate

    Sign In/Register for Dotsub to translate this video.