Forum Discussion

CraigC's avatar
CraigC
Helper I
9 years ago
Solved

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 = ...
  • fhill's avatar
    fhill
    9 years ago

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

     

fhill's avatar
fhill
Resident Rockstar
9 years ago

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

 

PieroC's avatar
PieroC
New Member
3 years ago

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.

 

Thanks in advance.
Appreciate the help!