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

Combo Charts in Power BI

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.

1 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") 

PBI_SuperUser_Rank@1x.png  

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

View solution in original post

5 REPLIES 5
stuart765
Frequent Visitor

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.

@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") 

PBI_SuperUser_Rank@1x.png  

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
Frequent Visitor

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

Bar chartsBar chartsVisual typeVisual type

@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:

Anand24_0-1679642935419.png

 

PBI_SuperUser_Rank@1x.png  

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
Super User
Super User

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

PBI_SuperUser_Rank@1x.png  

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

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors