Chart for multiple boolean columns

[danielec]

Hello everyone!

I have a simple form collecting a daily report of activities being accomplished.

Data example:

Day	Submitter	Activity 1	Activity 2	Activity 3
1/3/2020	agent1	true	true	false
1/3/2020	agent2	true	false	false
1/3/2020	agent3	false	true	false
2/3/2020	agent1	false	true	true
2/3/2020	agent2	false	false	false
2/3/2020	agent4	true	true	false

and so on...

I'd like to have a barchart with the count of "true" for each activity during a specified time period (single or multiple days). It would also be useful a timechart with Activity1, 2 ... and so on as series and the count of each one accomplished per day.

Is it possible?

Thanks in advance!

Daniele

[BA_Pete · Accepted solution]

Hi @danielec ,

As @Greg_Deckler said above, boolean can be a bit of a PITA in measures.
If you are able to convert your data to text the following measure should work fine for each activity:

_activity1qty = 
CALCULATE(
    COUNT('table'[Activity 1]),
    'table'[Activity 1] = "TRUE"
)

Once you have the three measures, stick them in a stacked column like this:

Stacked Column Chart - three measures all in 'Values', Day in 'Axis'

[danielec]

Thank you all! After I transformed the field to numeric everything was easy.

[Greg_Deckler]

Yeah, I believe that COUNTA will count boolean values. Could also use COUNTROWS. Believe it or not, I often find annoying limitations with boolean things in Power BI so I tend to use 1's and 0's instead.