Forum Discussion
Post PatronConstant y-axis value based on field value?
I would like to show the high and low reference values as a line on a line chart along with the actual test value, but I struggling with how to approach the problem. The data table looks like this:
Thanks for any suggestions.
14 Replies
MojoGeneThe intent is to show the lab value on a line chart with the high/low range of normal values like this:
- Ritaf1983
Super User
Hi MojoGene
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 - MojoGene
- 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.
