Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

If statement on a Boolean type (Measure)

Hey everyone!   I have a column that has a type of TRUE and FALSE (Boolean) and I am trying to make a measure that just outputs all the true values    I have a a column like so;   Time tracked ...
Need Help
Show and Tell
parry2k's avatar
parry2k
Super User
6 years ago

Anonymous why not create stacked bar chart and put Is Billable column on Legend and Time Tracked on values, it will do it.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I see that did the job! Is there a way to change the legend labels from True and False to Billable and Non-billable?

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous add a custom column in your model to get that label and use that on legend

     

    Legend = 
IF ( Table[Is Billable], "Billable", "Non-Billable" )

     

    Would appreciate if you give Kudos if my solution helped.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Absolute genius!

       

      So what if i wanted to display the different amounts on cards? Like 285 hours billable

      • parry2k's avatar
        parry2k
        Super User
        6 years ago

        Anonymous you can create a measure or put visual level filter and select value "Billable"