Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to Solution.
@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
@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
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
52 |