Forum Discussion
Post PatronConstant y-axis value based on field value?
Post Patron- Ritaf1983
Super User
Hi MojoGene
This is a data table, I still don't understand what you are trying to achieve....can you show an example?- MojoGene
Hi and thanks for jumping in. The chart effect I am trying to achieve is shown on the image as mentioned above. The significance of any lab value must be assessed in relation to what is "normal," i.e., the range of expected values. I was thinking that this might be accomplished with dynamic constant lines that change with the lab test.
- Ritaf1983
Hi MojoGene
There is no option to work with your sample data file because all data is about the same point in time + the values are not equal to the values on the pictures....
in general, you can add constant lines in this way :
After creating a line graph :and then format it.
Maximum line in the same way.These lines are dynamic:
Pbix is attached.
More guides about working with constant lines :
https://www.easytweaks.com/add-horizontal-line-power-bi-chart-visual/
https://blogs.perficient.com/2023/05/03/analytics-pane-in-power-bi-part1/
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
