Combo Charts in Power BI

[stuart765]

Everyone has been great in the past in providing assistance and I would appreciate assistance again. I have a Power BI bar chart where data for one client greatly exceeds other clients. I can change the outlier client appearance to a line graph when creating a combo chart. I have chosen a combo chart in Power BI and checked the second Y-axis but cannot find how the change the one bar to a line.  

Thank you in advance for your recommendations/solutions.

[stuart765]

My data consists of multiple locations. In Excel, I can create a combo chart and choose which location I want to appear as a line graph so the other locations do not appear skewed. Does Power BI allow switching one data element in a chart to a line vs. bar? I do not want to create a new table with just one location to create a combo chart. Thank yoy.

[Anand24 · Accepted solution]

@stuart765 ,
You can create a calculated measure for that particular location and then put that measure in Column Y-Axis
Example of such calculated measure:
Location1 Sales = CALCULATE(SUM(Sales), 'Table_Name'[Location] = "Location1") 

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[stuart765]

I created the chart from tables/data already in Power BI. I've included two pictures (screen shots).

Bar chartsVisual type

[Anand24]

@stuart765 ,
Whatever you need in the bar chart comparison will go in "Column Y-Axis". Whatever you need in the line chart will go into "Line Y-Axis".

Please refer below image:

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[Anand24]

Hi @stuart765 ,
Which combo chart are you using? What is the exact name of visualization? Is it some visual imported from app source?

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn