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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

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

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors