Forum Discussion

davewardd10's avatar
davewardd10
Frequent Visitor
8 years ago
Solved

Combo Chart Line Series

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

  • Anonymous's avatar
    Anonymous
    8 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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