Dynamic y-axis question

[MojoGene]

My PBI report shows a line graph of lab results for a number of different lab tests over a time range. The lab tests are individually selected with a drop down visual. For each lab test, there is a different "reference range," i.e., a range of normal values. If possible, I would like to have the high and low reference range values displayed on the y-axis. Here is an image of the report with the the tables as they appear in PBI Desktop. You will see here that because the tests results are so high the reference range, 9.0 to 13.2 seconds, does not appear on the y-axis:

It would also be useful to have the y-axis description change with each test because the values have many different units of measure, e.g., some are measured in milligrams per deciliter, some are seconds, some are percentages, etc.

Thanks for any suggestions.

[christinepayton]

Are you using field parameters? I think I know what you mean... the axis label is dynamic according to the field parameter you have selected by default (unless you enter a manual value, in which case you can't get the dynamic one back as far as I know), but you don't have control over the the label as far as adding text to it - it uses the name of the selected field parameter.

It is MUCH easier to put the dynamic bit, e.g. the units, in the title or subtitle of the chart if you're open to that. For those, you get the "fx" formula option to use a measure for the text, so you could write a measure that displays what you want for each selected field parameter. 

[MojoGene]

Thanks for the feedback. The concern is not about displaying text information about the reference range, but having the chart display the actual values in context of the reference range. As you can appreciate, in the sample above having the reference range in the chart would result in conveying not only the actual values on the line, but the visual effect of showing that the values are very high in relation to the reference range. 

[amitchandak]

@MojoGene , Not very clear. But Y-axis usually adjust to the changes unless min/max value used for axis