The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
86 | |
84 | |
35 | |
35 | |
34 |
User | Count |
---|---|
94 | |
79 | |
63 | |
55 | |
52 |