Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
CraigC
Helper I
Helper I

Create a pie chart from counting values in different ranges

 Hi Everyone

 

I need to create a pie chart from the resolution times column.

 

I have calculated the resolution time from open time to close time using the following formula:

Resolution Time = [CLOSEDATETIME]-[OPENDATETIME]

 

It is in a fixed decimal number format set to dont summarize.

 

Basically i want to be able to have a pie chart showing the percentage of tickets resolved in under 15 minutes, then 15 to 30 minutes, then 30 to 60 minutes then over 1 hour

 

Below i used this formula to try and switch values but cant do between 15 and 30 minutes (0.25 and 0.5) so dont think that will work.

 

Any ideas how to do this pie chart?

Ticket resolution Pie chart.JPG

 

 

1 ACCEPTED SOLUTION
fhill
Resident Rockstar
Resident Rockstar

I'll skip my many personal objections to the pie chart for now...  but I think this was what you were going for...?  I changed your 'Under 15 Min' to '0-15 Min' to make sorting easier...  Hope this helps, FOrrest

 

Graph = IF(Table1[Resolution Time] < 0.25,"0-15 Min",
IF(Table1[Resolution Time] >= 0.25 && Table1[Resolution Time] < 0.5,"15-30 Min",
IF(Table1[Resolution Time] >= 0.5 && Table1[Resolution Time] < 0.75,"30-45 Min",
IF(Table1[Resolution Time] >= 0.75 && Table1[Resolution Time] < 1, "45-60 Min",
IF(Table1[Resolution Time] >= 1,"Over 1 Hour","Error")))))

 

Capture.PNG




Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!


https://www.linkedin.com/in/forrest-hill-04480730/

Proud to give back to the community!
Thank You!




View solution in original post

3 REPLIES 3
fhill
Resident Rockstar
Resident Rockstar

I'll skip my many personal objections to the pie chart for now...  but I think this was what you were going for...?  I changed your 'Under 15 Min' to '0-15 Min' to make sorting easier...  Hope this helps, FOrrest

 

Graph = IF(Table1[Resolution Time] < 0.25,"0-15 Min",
IF(Table1[Resolution Time] >= 0.25 && Table1[Resolution Time] < 0.5,"15-30 Min",
IF(Table1[Resolution Time] >= 0.5 && Table1[Resolution Time] < 0.75,"30-45 Min",
IF(Table1[Resolution Time] >= 0.75 && Table1[Resolution Time] < 1, "45-60 Min",
IF(Table1[Resolution Time] >= 1,"Over 1 Hour","Error")))))

 

Capture.PNG




Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!


https://www.linkedin.com/in/forrest-hill-04480730/

Proud to give back to the community!
Thank You!




Hi there Fhill.

 

I have a similar problem but my data have some "distinct count" issue on it. My sales are scattered in quantities per net prices and don't know how to solve it. 

problem1.png
See? I have 3 distinct amounts for Ticket (numero documento) No 1 and also on No 10


I managed it on Power Pivot but just can't on Power Bi as you can see on shots I now add.

problem2.pngproblem3.png


I need a Dax formula for the ticket ranges on a ring chart like that.

 

Thanks in advance.
Appreciate the help! 

I know, but people like the "pretty wheel".

 

Worked perfectly! Thank you:)

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.