Combo Chart Line Series

[davewardd10]

Hi There,

I'm trying to create a combo chart in Power BI such that I can see both a clustered column set and two line series, similar to what you see in the screengrab from excel attached.

In Power BI I am able to create the clustered column chart which shows the conversion breakdown in columns with the device type as a series however I'm unable to add a line series to the FCPA measure. I created the FCPA measure within Power BI - FCPA = SUM(Table1[Spend])/SUM(Table1[Conversions]) - I presume in order to create the chart I want I need to create a seperate measure for both Smartphone FCPA and Computer FCPA? If this is the case can someone advise me as to the formula I should use here - Just an FYI my data set does include a column which specifies device type.

Kind regards,

David

[v-yuezhe-msft · Accepted solution]

@davewardd10,

Create the following measures in your table, then drag them to Line values of Line and clustered column chart and check if you get expected result.

Smartphone FCPA = CALCULATE([FCPA],Table1[Device]="Smartphone")
Computer FCPA = CALCULATE([FCPA],Table1[Device]="Computer")

Regards,
Lydia

[davewardd10]

Thanks Lydia that worked 🙂