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 August 31st. Request your voucher.
Hi Guys,
I am looking to implement a constant horizontal line in my line and stacked column chart. I currently have both line (right axis) and column values (left axis), when I try to pull the constant line data in, it adheres to the right axis,. However I'd like to use it as a target line against my column values and hence it should be measured against the left axis instead. Is there any way I can go about this?
Thanks in advance!
Hi @Anonymous ,
Check the below thread:
@Anonymous , You can create a measure that returns constant line and you can add that to clustered/stacked line chart.
Or you can use analytics pane to do that
https://docs.microsoft.com/en-us/power-bi/desktop-analytics-pane
Hi,
Unfortunately the Analytics pane is not available for me for that particular chart. As for the measure, would I put it in Column values or Line values? As I would like the line to adhere to the column y-axis.
Thanks!
User | Count |
---|---|
80 | |
74 | |
41 | |
30 | |
28 |
User | Count |
---|---|
107 | |
96 | |
53 | |
47 | |
47 |