Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to 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 !!! |
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")
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 !!! |
I created the chart from tables/data already in Power BI. I've included two pictures (screen shots).
Bar charts
Visual 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:
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 !!! |
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 !!! |
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
30 | |
20 | |
19 | |
13 | |
13 |
User | Count |
---|---|
28 | |
18 | |
18 | |
16 | |
14 |