Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet 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
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).
@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 !!! |
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
34 | |
32 | |
19 | |
12 | |
8 |
User | Count |
---|---|
52 | |
36 | |
29 | |
14 | |
12 |