Dual Axis Chart in Microsoft Power BI - Step By Step

If you want to know who should Learn Tableau and Why , get the answer to your question based on my experience with hundreds of professioinals during my tableau training in Gurgaon , Noida , Bangalore , Ranchi , Mumbai , Pune and other parts of India. You can read my blog here - Best Tableau Training in Gurgaon

If you want to know who should Learn Power BI and Why , get the answer to your question based on my experience with hundreds of professioinals during my Microsoft Power BI training in Gurgaon , Noida , Bangalore , Ranchi , Mumbai , Pune and other parts of India. You can read my blog here - Best Power BI Training in Gurgaon

 

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:

Data view:

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

Select Line and clustered column visualization:

 

Drag Quantity field into Line values field:

 

We can see two Y Axis:

Now we will check results for ‘Next level hierarchy’

Go to one more next level of hierarchy:

Click one more time to show next level:

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

Click on

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

 

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:

Expand X axis:

Expand Y axis:

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

Format few option for Y axis (Column):

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:

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

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

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

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

Format data colour and title fields:

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’:

Drill up

It was about Dual Axis charts.

 

If you want to know who should Learn Power BI and Why , get the answer to your question based on my experience with hundreds of professioinals during my Microsoft Power BI training in Gurgaon , Noida , Bangalore , Ranchi , Mumbai , Pune and other parts of India. You can read my blog here - Best Power BI Training in Gurgaon

 
If you want to know who should Learn Tableau and Why , get the answer to your question based on my experience with hundreds of professioinals during my tableau training in Gurgaon , Noida , Bangalore , Ranchi , Mumbai , Pune and other parts of India. You can read my blog here - Best Tableau Training in Gurgaon
 
 

Comments

There are no entries yet.
Please enter the code
* Required fields

Subscribe to our mailing list

* indicates required

Looking for Corporate Training ? Reach out to us at Akriti.Lal@instrovate.com

Reach out to us if you are looking for Corporate Training to Build The Next Generation Analytical Workforce with an in-depth understanding of  Exploratory Data Analysis , Data Visualisation, Data Analytics , AI First , Machine Learning & Deep Learning Training & Consulting helping them to take Data Informed Decision at each stage of the business. 

We understand that At the present times , the Entire Industry is in a Tranformation stage with the Softwares  being rebuilt with Artificial Intelligence Capabilities .

We need SMART WORKFORCE for the SMART SOFTWARES to reap the maximum return . 

 

Whatsapp at +91-9953805788 or email at - akriti.lal@instrovate.com if you would like to know more . 

 

  • Corporate Tableau Training in Gurgaon
  • Corporate Data Analytics Training in Gurgaon
  • Corporate Microsoft Power BI Training in Gurgaon
  • Corporate Microstrategy Training in Gurgaon
  • Corporate Google Data Studio Training in Gurgaon
  • Corporate Python Training in Gurgaon
  • Corporate Advance Analytics in R Programming Training in Gurgaon
  • Corporate Machine Learning Training in Gurgaon
  • Corporate Deep Learning Training in Gurgaon
  • Corporate Data Visualization Training in Gurgaon

 

Address

Instrovate Technologies

Noida, Gurgaon

 

akriti.lal@instrovate.com 

Hit Your Refresh Button To Rise Higher
Print Print | Sitemap
All rights reserved @ Instrovate Technologies
GSTIN : 09AAECI6862K1Z1

Terms Of Services    Privacy Policy    Disclaimer     Refund Policy    


Call

E-mail