cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
davewardd10
Frequent Visitor

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.Power BI Query.PNG

 

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

1 ACCEPTED SOLUTION
v-yuezhe-msft
Microsoft
Microsoft

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yuezhe-msft
Microsoft
Microsoft

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Thanks Lydia that worked 🙂

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!