Atvik
Heimsmeistaramót Power BI DataViz
Feb 14, 4 PM - Mar 31, 4 PM
Með 4 tækifæri til að taka þátt gætirðu unnið ráðstefnupakka og komist í LIVE Grand Finale í Las Vegas
Nánari upplýsingarÞessi vafri er ekki lengur studdur.
Uppfærðu í Microsoft Edge til að nýta þér nýjustu eiginleika, öryggisuppfærslur og tæknilega aðstoð.
APPLIES TO:
Power BI Desktop
Power BI service
In Power BI, a combo chart is a single visualization that combines a line chart and a column chart. Combining the two charts into one lets you make a quicker comparison of the data.
Combo charts can have one or two Y axes.
Combo charts are a great choice:
Athugasemd
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.
To follow along, use the Retail Analysis sample PBIX file.
From the upper left section of the menubar, select File > Open report.
Find your copy of the Retail Analysis Sample PBIX file.
Open the Retail Analysis Sample PBIX file in report view.
Select
to add a new page.
Start on a blank report page and create a column chart that displays this year's sales and gross margin by month.
a. From the Fields pane, select Sales > This Year Sales > Value.
b. Select Sales > Gross Margin This Year and drag it to the Y-axis well.
c. Select Time > FiscalMonth and drag it to the X-axis well.
The new visualization is similar to this one.
In the upper-right corner of the visual, select the More options ellipsis (...) and select Sort axis > FiscalMonth.
Select the ellipsis again and choose Sort axis > Sort ascending.
Convert the column chart to a combo chart. There are two combo charts available: Line and stacked column and Line and clustered column. With the column chart selected, from the Visualizations pane select the Line and clustered column chart.
From the Fields pane, drag Sales > Last Year Sales to the Line y-axis bucket.
Your combo chart should look something like this:
In this task, we compare gross margin and sales.
Create a new line chart that tracks Gross Margin Last Year % by FiscalMonth.
Select the ellipsis to sort it by FiscalMonth, then select the ellipsis again and choose Sort axis > Sort ascending.
In January, GM% was 35%, peaked at 45% in April, dropped in July and peaked again in August. Will we see a similar pattern in sales last year and this year?
Add This Year Sales > Value and Last Year Sales to the line chart. The scale of Gross Margin Last Year % is much smaller than the scale of Sales which makes it difficult to compare.
To make the visual easier to read and interpret, convert the line chart to a Line and stacked column chart.
Drag Gross Margin Last Year % from Column y-axis into Line y-axis.
Power BI creates two axes, thus allowing the semantic models to be scaled differently; the left measures sales dollars and the right measures percentage. And we see the answer to our question: yes, we do see a similar pattern.
Select the paintbrush icon
to open the Formatting pane.
Set Y-axis to On, then select the down arrow to expand the Y-axis options.
Set Y-axis > Values > Display units to Millions.
Set Y-axis > Title to On, then set Style to Show title only
Set Secondary y-axis to On to display options for formatting the line chart portion of the combo chart.
Under Secondary y-axis, set Title to On.
Your combo chart now displays dual axes, both with titles.
Optionally, modify the text font, size, and color and set other formatting options to improve the display and readability of the chart.
From here, you might want to:
Highlighting a column or line in a combo chart cross-highlights and cross-filters the other visualizations on the report page, and vice versa. Use visual interactions to change this default behavior.
Atvik
Heimsmeistaramót Power BI DataViz
Feb 14, 4 PM - Mar 31, 4 PM
Með 4 tækifæri til að taka þátt gætirðu unnið ráðstefnupakka og komist í LIVE Grand Finale í Las Vegas
Nánari upplýsingarÞjálfun
Eining
Use visuals in Power BI - Training
Create and customize visuals to present data in compelling and insightful ways.
Vottorð
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.
Skjöl
Create line charts in Power BI - Power BI
Learn how to use line charts in Power BI.
Column chart format settings - Power BI
This document explains all available Format settings for Column charts in Power BI Desktop and Power BI Service.
Customize X-axis and Y-axis properties - Power BI
Customize X-axis and Y-axis properties