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'

     

     

BA_Pete's avatar
BA_Pete
Super User
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'

 

 

  • danielec's avatar
    danielec
    New Member
    6 years ago

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