cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rassy85 Frequent Visitor
Frequent Visitor

Count visits to a destination and visualize in a donut chart

Hi all,

 

Power BI is brand new to me and I'm struggling with creating a donut chart which visualizes number of visits to a destination.

 

Table:

2019-03-21_14-24-27.png

 

I want Power BI to count each time a specific destination appears in the list. The wish is that I'll get the below output:

2019-03-21_14-27-19.png

 

Hope there's a saviour out there!

1 ACCEPTED SOLUTION

Accepted Solutions
bhpage Regular Visitor
Regular Visitor

Re: Count visits to a destination and visualize in a donut chart

Hi,

 

If I'm understanding correctly, your ask is pretty straightforward. I replicated that same sample data set and pulled it into Power BI. All you need to do is select the donut chart visual, and then pull "Visits"  into the values section, and pull Destination onto either the detail or legend section. Either should work in this basic example. Here's an image:

Desination Visits.PNGLet me know if this works for you.

 

Ben

 

3 REPLIES 3
bhpage Regular Visitor
Regular Visitor

Re: Count visits to a destination and visualize in a donut chart

Hi,

 

If I'm understanding correctly, your ask is pretty straightforward. I replicated that same sample data set and pulled it into Power BI. All you need to do is select the donut chart visual, and then pull "Visits"  into the values section, and pull Destination onto either the detail or legend section. Either should work in this basic example. Here's an image:

Desination Visits.PNGLet me know if this works for you.

 

Ben

 

Community Support Team
Community Support Team

Re: Count visits to a destination and visualize in a donut chart

Hi @rassy85 

 

You may also change the 'Detail labels' to show the counts.

1.png

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
rassy85 Frequent Visitor
Frequent Visitor

Re: Count visits to a destination and visualize in a donut chart

Thanks Ben!

 

It did'nt work on my dataset - the data seems to be corrupted some how. I've made some workarounds and now it works.