From the course: Power BI Data Visualization and Dashboard Tips, Tricks, & Techniques

Unlock the full course today

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

Filter data for line and area charts

Filter data for line and area charts - Power BI Tutorial

From the course: Power BI Data Visualization and Dashboard Tips, Tricks, & Techniques

Start my 1-month free trial

Filter data for line and area charts

“

- [Instructor] We just created a bar chart. What happens if we click line chart now? Power BI tries to join our data points with a line. Let's make that bit bigger and you can see, or you may be able to see, it's put the product names in very small font at the bottom and net sales across the top. This isn't good design for a report because lines indicate a continuation of data, so this line to me means that there is some link between the Skype value there and the team's value, and I think that's misleading. Lines really are great for showing a value over time but sales data don't really flow from one product to another in the same way. So let's change this back to a bar chart and create a new visual with data that's better suited to align. Instead of product, we're going to use calendar date as our axis we're going to use calendar date as our axis and then units as our value. and then units as our value. Power BI…

Contents