LOADING

Type to search

Dual Axis Chart in Microsoft Power BI – Step By Step

To Know more about the Different Corporate Training & Consulting Visit our website www.Instrovate.com Or Email : info@instrovate.com or WhatsApp / Call at +91 74289 52788

Data Analytics PowerBI

Dual Axis Chart in Microsoft Power BI – Step By Step

Share

You Can either Watch the Video on our YouTube Channel ( Don’t Forget to Subscribe by Clicking Red Button) or You can read the Blog with Step By Step Instruction as below – www.YouTube.com/c/InstrovateTechnologies

 

Today we will go through Dual Axis (one X-Axis and two Y-Axis) chart using a Combo chart (Combo chart is to combine line chart and a column chart). We can use this type of chart when we have more measures with different value range.

Upload data in Power BI:

Dual Axis Chart in Microsoft Power BI - Step By Step 29

Data view:

Dual Axis Chart in Microsoft Power BI - Step By Step 30

Go to Report and select Order date, Sales and Profit field for Bar chart:

Dual Axis Chart in Microsoft Power BI - Step By Step 31

Select Line and clustered column visualization:

 

Dual Axis Chart in Microsoft Power BI - Step By Step 32

Drag Quantity field into Line values field:

 

Dual Axis Chart in Microsoft Power BI - Step By Step 33

We can see two Y Axis:

Dual Axis Chart in Microsoft Power BI - Step By Step 34

Now we will check results for ‘Next level hierarchy’

Dual Axis Chart in Microsoft Power BI - Step By Step 35

Go to one more next level of hierarchy:

Dual Axis Chart in Microsoft Power BI - Step By Step 36

Click one more time to show next level:

Dual Axis Chart in Microsoft Power BI - Step By Step 37

Now we can see results with respect to Days on dual axis chart.

Dual Axis Chart in Microsoft Power BI - Step By Step 38

Click on

Dual Axis Chart in Microsoft Power BI - Step By Step 39

Click on Drill up and go to previous level of chart hierarchy from where we have started drilling down:

Dual Axis Chart in Microsoft Power BI - Step By Step 40

 

Dual Axis Chart in Microsoft Power BI - Step By Step 41

Here we can see results for by Years, Quarter, month and days for Order Date with Sales and Profit in Column and for Quantity in line chart.

Drill Up to previous level and Click on Format:

Dual Axis Chart in Microsoft Power BI - Step By Step 42

Expand X axis:

Dual Axis Chart in Microsoft Power BI - Step By Step 43

Expand Y axis:

Dual Axis Chart in Microsoft Power BI - Step By Step 44

We can see two Y-axis, one for column and one for line.

Format few option for Y axis (Column):

Dual Axis Chart in Microsoft Power BI - Step By Step 45

In This Show secondary option is On, it allows us to format second y axis. If we set this off, we cannot see format option for second y axis:

Dual Axis Chart in Microsoft Power BI - Step By Step 46

Now we don’t have Y-axis(line) option for formatting.

Again, click on show secondary option and make it ‘On’:

Dual Axis Chart in Microsoft Power BI - Step By Step 47

Now we can see Y-axis (Line) option for format.

Now let’s make some changes in Y Axis (Line):

Dual Axis Chart in Microsoft Power BI - Step By Step 48

Format data colour and title fields:

Dual Axis Chart in Microsoft Power BI - Step By Step 49

It was all about dual Y-axis chart in combo chart.

 

We can change ‘Line and clustered column chart’ into ‘Line and stacked column chart’:

Dual Axis Chart in Microsoft Power BI - Step By Step 50

Drill up

Dual Axis Chart in Microsoft Power BI - Step By Step 51

It was about Dual Axis charts.

You can watch the step by Step video to Create Dual Axis or Combo Chart in Power Bi. We keep adding important topics materia on the YouTube Channel so don’t forget to SUBSCRIBE to the Channel .

Dual Axis Chart in Microsoft Power BI - Step By Step 52

For Corporate Training on Tableau , Power BI , QlikSense , Data Analytics , Data Science , Agile , Scrum SAFe, Pentaho contact us at info@instrovate.com and visit our Website – https://instrovate.com/

 

Click on the Instrovate Icon to Visit Our Website to see the Comprehensive list of Courses and Consulting that we offer as Corporate , Online & Academic Training and During our Consulting Project works

Tags:

You Might also Like

Leave a Comment

Your email address will not be published. Required fields are marked *