Forum Discussion

deniseb's avatar
deniseb
Regular Visitor
4 years ago
Solved

Countif

Hello, In my Power BI analysis, I evaluate all calls from our telephone system. This includes the duration per call. Now I would like to create a pie chart that shows how many calls lasted under 8 mi...
  • amitchandak's avatar
    4 years ago

    deniseb , If they are non overlapping you can create a  new column and use in pie visual

     

    Type = Switch(true() ,

    [Overlapping in Min] <8 , "Less Than 8",

    [Overlapping in Min] <20 , "Less Than 20",

    "More than 20"

     

    )

     

     

    If they are overlapping create measures and then do not use legends only use measures