Forum Discussion
Creating Column Chart, Counting If Yes,
Hi, I'm very new to Power BI. I've tried searching for this answer, but am only seeing similar questions, but not quite exact.
I would like to create a bar/column chart. The Horizontal Axis contains Shifts (A, B, C, D, Days, Other Shift). There are four columns for which the values are counted from. (Behavioural, Hazard, Risk, Near Miss). I need the chart to show me a count of the word "Yes" from each of the four columns, however, I can only seem to apply "Yes" to one at a time. In the example below, it's only showing the total combined "Yes", "No" and blanks.
Yeah, I guess that the default action of Power BI would just be to count all. If you make a measure similar to what I wrote in my previous post for each of your four columns, it should work as they'll only consider rows where the relevant column contains yes.
5 Replies
What exactly are you feeding into the visual? Are you putting in a measure that has something like BehaviouralCount = calculate(countrows[yourtable],Behavioural="Yes"), or something else?
I think that's just it, I don't know what I'm doing :( I've just created the chart and dragged my columns into it. I'm trying to adjust the filters, but I'm thinking I need to use measures?
Yeah, I guess that the default action of Power BI would just be to count all. If you make a measure similar to what I wrote in my previous post for each of your four columns, it should work as they'll only consider rows where the relevant column contains yes.
