Donut chart with Median range as legend

[alice11987]

Hi, 

I have a table which contains the following columns:

And I would like to create a Donut chart like this:

• legend by Median days range (<15 days,15-30 days, 31-60 days & 60+ days) 
• case count as value

How can I achieve this? 

thank you!

[danextian]

Hi @alice11987 

If you have the days count in your data, you can simply create a calculated column and use it as the legend.

=
SWITCH (
    TRUE (),
    table[dayscolumn] >= 61, "60+ days",
    table[dayscolumn] >= 31, "31-60 days",
    table[dayscolumn] >= 15, "15-30 days",
    " <15 days"
)

[alice11987]

Hi, thanks for your answer, but the days i need are in median, not total

[Ritaf1983]

Hi @alice11987 
Yes.

You need to cluster your medians into groups by median and then put them on the chart by ranges.
Here is a link to a tutorial for making needed segmentations ( in your case by duration)

 https://hacksfordataanalysis.com/2020/08/19/group-by-range-2-ways-to-group-data-in-power-bi/

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly