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

Do you know what you installed while custom installing SQL Server 2022?

 When you install any software in Windows OS, the key information gets into the Registry and some of which you can look up in the control pa...