Forum Discussion
deniseb
4 years agoRegular Visitor
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...
- 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
amitchandak
4 years agoSuper 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