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

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now

Reply
Anonymous
Not applicable

Line Values not consistent with graph

Hello,

 

As you see below, I have two line values that are aligned to the values on the right axis, and columns that are aligned to the left axis. I have read that Power BI is not able to have columns and line values aligned to the same axis, therefore I have created a column in my data for one of my line values (purple line) to match with the hypothetical amount that would correspond with the value on left axis that it needs to be.

 

The problem that I am having is that the values on right axis are not staying consistent, therefore not allowing me to find the set amount that I need to match the right visual location of the left axis. (Check the difference in left axis in my screenshots below while value on right axis has scaled down).

 

Is it possible to insert a shape and place it at the right amount for each of my filters in my slicer?

 

Please let me know if you have any ideas.

 

uic80116_0-1610995014708.png

 

uic80116_1-1610995544547.png

 

2 REPLIES 2
parry2k
Super User
Super User

@Anonymous sorry your question is not very clear. can you share sample data and expected result and what you would like to see on the visual.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous
Not applicable

@parry2k 

 

I would like to see the target line (budget) be shown as 0.539 on left axis. But only column values are correlated to left axis. Line values are correlated to right axis, which is what I am trying to figure out... how to make the value consistent to where the visual look accurate.

 

uic80116_0-1610998022690.png

 

Helpful resources

Announcements
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.