cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Pie Chart

Hi All

 

i need some help with a pie chart. I have a data set that contians data that is not equal in value, see imagedata pie chart.JPG

 

The outcome i am looking for is:

 

A 5 segmented Pie chart of equal size even if the data is not

The segment to be blank / white if the value if less than the current values in the above data set

Each segment to be a diffrent colour from the other. 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper I
Helper I

Re: Pie Chart

Sorry but i am doning somthing worng here or it is not working for me. 

 

please see below screeen shot. 

 

in this instance i have followed you instructions.

Added a filter to the Pie chart so it only shows CableID 2

then added the filter to Partial string test >100. the value in the filed has been adujsted in the data set to 99 so is should not show. when i apply this filter the whole chart disapears.

Capture9.JPGCapture10.JPG

 

View solution in original post

17 REPLIES 17
Highlighted
Continued Contributor
Continued Contributor

Re: Pie Chart

hey why dont you create a column for the categories defined in different columns so that your pie chart is depicted on the basis of the values

Category Value
Pre term testing 5
Preparations1
0
b c12
d4
Highlighted
Helper I
Helper I

Re: Pie Chart

Thanks. 

 

The data is synced into a SQL table and then brought into Power BI in this format. i can do much in the way of changing it at source. 

 

i have managed to get the equal segments now thought a Count of values. However i can seem to apply a filter to this to not show item that are not equal to the maximum amount. 

 

Filter example.

 

if the value of pre-term-testing is less than 15 then don't show or colour white

Highlighted
Solution Sage
Solution Sage

Re: Pie Chart

Hi @Colinu

 

This job can be done with calculated column and IF

 

What you should is : 

 

1 - Create a calculated column that = 1 (So that every segment will look the same size) and put your real data value in the tooltip area so that when a user wants to see the data he only have to put his mouth hover.

 

2 - Control on colors are tricky but if you don't want to show it, simple add a visual level filter : Your Value is greater than 'input value' (not exactly what is down below but you will have the option to put greater than)

topn.PNG

 

3 - And you can choose the color in the data color section in Format

 

- Quentin

Highlighted
Helper I
Helper I

Re: Pie Chart

Thanks Qunitin

 

i am not quite sure i understand. 

 

if all values become equal to 1 then the segments will be equal however i cant then filter on the visual as the values are always 1. 

 

Colin

Highlighted
Solution Sage
Solution Sage

Re: Pie Chart

@Colinu

 

You have to add the real value to the filter, not the new column that's equal to 1

 

- Quentin

Highlighted
Helper I
Helper I

Re: Pie Chart

I have created the columns but then i cant filter on a count and if i try to sum or aCapture7.JPGny other option then the i get no value in the field.

Highlighted
Solution Sage
Solution Sage

Re: Pie Chart

@Colinu

 

Can you share a sample of your data ? 

 

 

- Quentin

Highlighted
Helper I
Helper I

Re: Pie Chart

how do i do that?

Highlighted
Solution Sage
Solution Sage

Re: Pie Chart

@Colinu

 

You can go to the data tab > Power Query editor and copy the 10 first line of your datas for example

 

If you have sensitive data, post a dummy sample 

 

- Quentin

Helpful resources

Announcements
Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Top Solution Authors