cancel
Showing results 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

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?

1 ACCEPTED SOLUTION
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")))))

Please give Kudos or Mark as a Solution!

Proud to give back to the community!
Thank You!

3 REPLIES 3
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")))))

Please give Kudos or Mark as a Solution!

Proud to give back to the community!
Thank You!

New Member

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.

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.

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

Appreciate the help!

Helper I

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

Worked perfectly! Thank you:)

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

#### Power BI Monthly Update - July 2024

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

#### Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors