Forum Discussion

Meryam's avatar
Meryam
New Member
4 years ago
Solved

Control Chart - All data

Hello,   I would like to create a control chart with the PBI. My data are temperatures measurmrnts  according to the date. I succeeded in creating the maximum line +3s and the minimum line -3s. ...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Meryam ;

    Try to modify it,

    STD = //CALCULATE(STDEV.S(Feuil1[Valeurs]),REMOVEFILTERS(Feuil1[Date ]))
VAR _TABLE=SUMMARIZE(ALL('Feuil1'),[Date ],"1",SUM([Valeurs]))
return STDEVX.S(_TABLE,[1])
    Mean = DIVIDE( CALCULATE(SUM([Valeurs]),ALL(Feuil1)),CALCULATE(DISTINCTCOUNT('Feuil1'[Date ]),ALL(Feuil1)))

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Meryam's avatar
Meryam
New Member
4 years ago

Test with Excel, i want the same graphic on PBI

amitchandak's avatar
amitchandak
Super User
4 years ago

Meryam , Create measures like these and use that in y-axis constant line using analytics pane

 

M1 = maxx(allselected(Table), Table[temperature]) +3

 

M1 = minx(allselected(Table), Table[temperature]) - 3