Red cross weight chart how to#
Red cross weight chart pro#

If your visual is very dense, Power BI will select the closest point to where you click on the visual. When you select a data point, Power BI adds markers indicating which point (for a single line) or points (if there are two or more lines) are the source for the cross-highlighting and cross-filtering of the other visuals on the report page. On a line chart, a single data point is the intersection of a point on the x axis and y axis. To follow along, open the Market Share tab. Selecting a data point on a line chart cross-highlights and cross-filters the other visualizations on the report page. In our example below, we can display sales and total units together on one chart by adding a second y axis.įor information about using the Filters pane, see Add a filter to a report. You can learn all about combo charts by reading Combo charts in Power BI. To display highly diverging values on one chart, use a combo chart. In fact, the red line for total units appears to be zero. What if you want to look at total sales and total units on the same chart? Sales numbers are so much higher than unit numbers, making the line chart unusable. Add additional lines by dragging Geo > Region to the Legend well. Instead of looking at total units for all regions as a single line on the chart, let's split out total units by region.

Red cross weight chart how to#

Let's look at adding additional lines to our current chart and then learn how to format our chart when the values represented by the lines are different. In some cases, the values on the lines may be so divergent that they don't display well together. Line charts can have many different lines. Optionally, adjust the size and color of the chart's text. Drop it under the heading Filters on this visual.Ĭhange Advanced filtering to Basic filtering and select 2012, 2013, and 2014. From the Fields pane, select Date > Year and drag it onto the Filters pane. If your Filters pane is collapsed, expand it now. Power BI creates a column chart on your report canvas.Ĭonvert to a line chart by selecting the line chart template from the Visualizations pane.įilter your line chart to show data for the years 2012-2014. Create a line chartįrom the Fields pane, select SalesFact > Total units, and select Date > Month.

Red cross weight chart pro#

Sharing your report with a Power BI colleague requires that you both have individual Power BI Pro licenses or that the report is saved in Premium capacity.