Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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
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
Thanks Lydia that worked 🙂