Forum Discussion
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 minutes, under 20 minutes and over 20 minutes. How should I proceed? I have already tried with a count formula but without success.
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
1 Reply
- amitchandak
Super User
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