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.  ...
  • 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

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

  • davewardd10's avatar
    davewardd10
    Frequent Visitor
    8 years ago

    Thanks Lydia that worked :)