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,
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.
But the problem is that i can't get all the point on the chat (x=temperature).
PBI propose to plot the sum, the min, the max, the mediane...etc.
I triered to modify in the "Data" tab and put don't summarize in place of sum but nothing changes.
I did the test with Excel ans i get the disired result, but with PBI i can't get it.
Please find here my BI file: https://www.dropbox.com/s/tdh1w0mywp78h12/Test%20PBI.pbix?dl=0
I think you for your help.
Solved! Go to Solution.
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.
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.
Test with Excel, i want the same graphic on PBI
@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
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 |
---|---|
112 | |
103 | |
75 | |
66 | |
63 |
User | Count |
---|---|
142 | |
105 | |
102 | |
81 | |
68 |