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

Encryption and connecting to SQL Server using SSMS

 This post is describes connecting to SQL Server 2022 using the SQL Server Management Studio and the encryption of connection. For installin...