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:
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 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’:
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 .
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 - email@example.com if you would like to know more .