cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
law_90
New Member

Creating Pie Chart by grouping user

Hi all,

I am totally new to Power BI. So I have a lot more to learn, but to speed up things, I am going to ask my question here.

I currently having the below visual table:

law_90_0-1673593260925.png

How can I create a Pie Chart visual with this visual table that it will just showing the owner of NOT FOUND and also all the owner as a group?
I mean my pie chart should looks like 34 NOT FOUND and 31 FOUND only.

 

Your guidance is very much appreciated.

Thank you!

 

1 ACCEPTED SOLUTION
olgad
Solution Sage
Solution Sage

Hi there,
right click on your column owner and create a new group

olgad_0-1673733349965.png

Select Not found then Group

olgad_1-1673733396179.png

Tick include other values 

olgad_2-1673733441595.png

Click twice on the Other, if you need to rename it

olgad_3-1673733479517.pngolgad_4-1673733521138.pngolgad_5-1673733544178.png

There you have it


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

View solution in original post

1 REPLY 1
olgad
Solution Sage
Solution Sage

Hi there,
right click on your column owner and create a new group

olgad_0-1673733349965.png

Select Not found then Group

olgad_1-1673733396179.png

Tick include other values 

olgad_2-1673733441595.png

Click twice on the Other, if you need to rename it

olgad_3-1673733479517.pngolgad_4-1673733521138.pngolgad_5-1673733544178.png

There you have it


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

Helpful resources

Announcements
Winner of T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Find out who won the T-Shirt Design Challenge and the top 3 finalists.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.