Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

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
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.