The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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.
@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.
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.
User | Count |
---|---|
69 | |
68 | |
64 | |
54 | |
28 |
User | Count |
---|---|
112 | |
81 | |
65 | |
48 | |
43 |