Sunday, July 29, 2018

How do I create a Combo chart in Power BI?

Combo charts or charts of type in VISUALIZATIONS which share the same x-Axis.  First of all you need to choose the type of chart that you want to create.

Here is a clustered column chart from one of my previous posts.


ComboChart_0

This shows a chart of male, female and total populations in four of Indian States, Andhra Pradesh, Tamil Nadu, Karnataka and Kerala (all South Indian states).

Now I change this chart type to Line and Clustered Column Chart. The chart will not change.


ComboChart_1

Now go back to the Fields tab under VISUALIZATIONS as shown here.


ComboChart_2

Now drag one of the fields (Female in this case) under FIELDS to the space under Line Values under the VISUALIZATIONS|Fields as indicated in the next image.

ComboChart_3

Now the Chart appears as shown, you see the Line chart superimposed on the Column chart.


ComboChart_4

Now go back to Format under VISUALIZATIONS and expand Shapes as shown here.


ComboChart_5

Here, you can turn-off the shaded area under the line graph. You can choose several other visual items a shown here.


ComboChart_6

You can also have a combo chart using the Line and Stacked Column chart as shown here:


ComboChart_7









No comments: