Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
hello,
am new to power BI, and am trying to plot a levey jenning standard deviation chart on power BI, that shows a minimum of 20% and max of 30% deviation from both ends of the ideal concentrataion(ideal concentration varies from 2-2000 in no particular order) and also having the ideal concentration line constant on the gragh when ever an ideal concentration is selected from the slicer. below is a sample of my data which as the calculated concentration on the y axis and the sample on the x axis.
Solved! Go to Solution.
Well, I was thinking something like:
Ideal = AVERAGE([Ideal Concentration]) Ideal20%Above = [Ideal]*1.2 Ideal20%Below = [Ideal]*.8
Well, I can imagine a measure that uses HASONEVALUE and if so, displays the AVERAGE, MAX or MIN of Ideal Concentration. You could then have 2 additional measures for 20% above and 30% below, or whatever, of this measure. Then you just display then in the line chart and they would come out as constant lines.
thanks. to create a measure for this what fomular should i use to achieve the % line
Well, I was thinking something like:
Ideal = AVERAGE([Ideal Concentration]) Ideal20%Above = [Ideal]*1.2 Ideal20%Below = [Ideal]*.8
thank you so much for the answer, i also have a situation that i would like to implement a flag if any of the sample concentration exceeds 30% above and 30% below an email should be sent notifying me of the sample that is out of range. thanks you
Can you paste that sample data as text? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
hello please see sample data as requested thanks
SampleConcentration | Analyte | CalculatedConcentration | PercentageDiviation | MachineName | TestDate | IdealConcentration |
A_090118_POS_QC_50 | Lamotrigine | 37.0688 | -25.8623 | APOLLO_POSQC_090118 | 9/7/2018 | 50 |
A_090118_POS_QC_50 | Fluoxetine metabolite | 119.024 | 138.047 | APOLLO_POSQC_091118 | 9/11/2018 | 50 |
C_090518_POSCAL_1000 | Doxepin | 1015.36 | 1.53557 | GALACTUS_POSCAL_090518 | 9/10/2018 | 1000 |
please see sample data below, hope that works. thanks
SampleConcentration | Analyte | CalculatedConcentration | PercentageDiviation | MachineName | TestDate | IdealConcentration |
A_090118_POS_QC_50 | Lamotrigine | 37.0688 | -25.8623 | APOLLO_POSQC_090118 | 9/7/2018 | 50 |
A_091118_POS_QC_50 | Fluoxetine metabolite | 119.024 | 138.047 | APOLLO_POSQC_091118 | 9/11/2018 | 50 |
C_090518_POSCAL_1000 | Doxepin | 1015.36 | 1.53557 | GALACTUS_POSCAL_090518 | 9/10/2018 | 1000 |
B_091118_POSCAL_50 | Hydrocodone | 51.3164 | 2.63289 | BRYNHILDR_POSCAL_091118 | 9/11/2018 | 50 |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |