Forum Discussion
Constant y-axis value based on field value?
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
Hi MojoGene
Now your sample has just one test ....if I understand correctly the table that you attached.So I used again my file.
You can create customized constants.
Ob the first step you need to create dimensions for date and lab tests with unique values.These dimensions should be used as slicers and categories on the graph
Then you can create measures for constants :
sum_for_Max = if(SELECTEDVALUE('location_T'[Location],0)=0,"",CALCULATE(max(space_missions[Price]),ALLSELECTED('calendar'[Date])))sum_for_min = if(SELECTEDVALUE('location_T'[Location],0)=0,"",CALCULATE(min(space_missions[Price]),ALLSELECTED('calendar'[Date])))Result :
PBIX is attached
More information about dimension tables :
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi MojoGene
You can work with every time granularity that you want, just create a time dimension table.
https://www.youtube.com/watch?v=-q7v56p192M&t=15sIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi MojoGene
Now your sample has just one test ....if I understand correctly the table that you attached.
So I used again my file.
You can create customized constants.
Ob the first step you need to create dimensions for date and lab tests with unique values.
These dimensions should be used as slicers and categories on the graph
Then you can create measures for constants :
Result :
PBIX is attached
More information about dimension tables :
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Thanks again for your extraordinary effort. I can follow your explanation very well, but this will not work for my needs because the time dimension on the calendar (days) forces the lab results to be summarized for each day. The test results are most meaningful when shown as individual, non-aggregated values. The test results might provide some useful information if aggregated as AVE, MIN or MAX, but a SUM is meaningless for this context.
Would I be able to get HOURS on the x-axis?
Thanks again, .@Ritaf1983 I have been able to get the hour dimension as you directed, although the results displayed at the hour granularity are not as expected. This is the display of average hourly value, which shows only 7 data points over the 20-day period of data. (Similar results for SUM, MAX, MIN.)
If a date with no data point is selected the graph is blank.
Based on your advice above, I did achieve the result I was looking for, but I achieved this using only the Date-Time field from the lab data table:
I am going to mark this as an accepted solution and once again extend my thanks for your extraordinary efforts. Above an beyond the call of duty.
Hi MojoGene
You can work with every time granularity that you want, just create a time dimension table.
https://www.youtube.com/watch?v=-q7v56p192M&t=15sIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
I feel like I am very close here, but I can't seem to get Hours granularity on the Date hierarchy.