Sunday, July 29, 2018

Creating Combo charts 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:

Post a Comment

Is Vector Search in SQL Server 2025 the Key to Unlocking New Data Insights?

 The advent of AI has ushered in ground breaking changes in most areas of technology. AI is synonymous with a humongous amount of data, data...