How To Use Combo Chart In Power BI ?

            

            How To Use Combo Chart In Power BI

When to use a Combo Chart?

Combo charts are good to use-

• To evaluate the correlation between two measures in one visualization on Power BI
• If the x-axis is quite similar for both line and column chart.
• If you want to find the relation between two measures within a single visualization.
• When you want to use the space properly. Creating two graphs takes more space in the canvas as compared to combining the graphs.

Click here to enroll : - Udemy Power BI Free : Your first Power BI Sales Dashboard

You can use combo charts both in power BI desktop or in  Power BI Service. In this example, we are going to use power BI desktop.

For example, we have a row data sample file of Retail analysis.

To create a combo chart first import the dataset into your power BI desktop by following these steps.

Click on Get Data > Select all the tables>Press Load button. You will see data has been imported.

When the dataset is imported on Power BI desktop then we need to edit the data according to our requirements. In this case, we manipulate the data in 5 distinct like Sale, Distinct, Item, Store and Time.

We are going to create Gross Margin this year, this year sales and last year sales by Fiscal Month. To create this

1. First, we take the value of gross margin this year from sales table drag it into the canvas.

2. Then we drag the column name this year sales value and last year sales from sales table.

3. Then we choose the fiscal month from the timetable.

4. Put the last year sales in the line value field.

5. Put gross margin this year and this year sales in the column value field.

6. We will put the fiscal month in the shared axes because it will be the same for both the graph.

7. There are two visualizations present in this report. You can use either Line and stacked column chart or line and cluster column chart. It is shown below.

8. The below combo chart is going to be created from following the above steps.

Click here for : Top 30 Power BI Interview Questions