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

Dual Axis Chart in Microsoft Power BI - Step By Step

 

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 belowwww.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:

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.

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 .

 
 

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

Comments

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

Subscribe to Our YouTube Channel To recieve updates on Free Learning

 

 

Visit Our Website to View the Upcoming Training Schedule

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

Subscribe to Our YouTube Channel To Receive Updates on the Latest Free Learning Video Added

Print Print | Sitemap
All rights reserved @ Instrovate Technologies
GSTIN : 09AAECI6862K1Z1

Terms Of Services    Privacy Policy    Disclaimer     Refund Policy    


Call

E-mail