Forum Discussion
Control chart for binary (yes/no) variable
Good morning, I work in Quality Improvement and control charts are something we use everyday. Creating a control chart for continuous data is quite simple but I am having tremendous difficulty in c...
rubio3003 I am not very familiar with control charts but I did a quick search and I think I have the idea. If this isn't it, would it be possible to share a small table of what you the data looks like and even a drawing of what the chart is you are trying to create? Thanks!
I do think for scatter plots in power bi you need measures, which may be the issue here?
For your pass/fail, this can converted to a percentage with:
Things = countrows('Table')
Pass Percentage = divide(caclulate([Things]),'Table'[Pass/Fail]="Pass"),[Things])
now to aggregate by different ranges, you could do something like:
Pass Percentage Avg Per Week = averagex(values('Date'[WeekOf]),[Pass Percentage]))
you can do that by median, min, max, etc.