Forum Discussion

danielec's avatar
danielec
New Member
6 years ago
Solved

Chart for multiple boolean columns

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 t...
Need Help
  • BA_Pete's avatar
    BA_Pete
    6 years ago

    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'

     

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

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.