Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Colinu
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

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
quentin_vigne
Solution Sage
Solution Sage

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

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

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.

@Colinu

 

Can you share a sample of your data ? 

 

 

- Quentin

how do i do that?

@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

hi thanks

 

i can share it but i cant see how i attach it to the post on here?

 

@Colinu

 

Just copy the table and paste it here

 

- Quentin

StringCable IDSizeTowerPre-term TestingPreparationsTerminationsPost term testingPartial string testing
 2 115.0020.0015.005.00100.00
 AB01 - AB05 AB017.50 15.005.00100.00
 AB06 - AB02 AB027.50 15.005.00100.00
 AB02 - AB01 AB025.00 15.005.00100.00
 AB08 - AB03 AB035.00 15.005.00100.00
 AB03 - AB04 AB035.00 15.005.00100.00
 AB03 - AB04 AB045.00 15.005.00100.00
 AB01 - AB05 AB05  15.005.00100.00
 AB11 - AB06 AB06  15.005.00 
 AB06 - AB02 AB06  15.005.00 
 AB12 - AB07 AB07  15.00  
 AB07 - AB08 AB07  15.00  
 AB07 - AB08 AB08  15.00  
 AB08 - AB03 AB08  15.00  

@Colinu

 

Your string and size column are empty ? 

 

- Quentin

They are not important for the time being.

 

@Colinu

 

 

First thing i've did is replace the BLANK value by 0. Then everything that looked like TEXT TYPE I turned it into NUMBER.
Example : 15.00 : 15 

Example : 7.50 : 7,5

 

Then

I went back to the pie chart : 

Under Filter : Visual filter level 

I add Partial String testing (NOT the number of Partial string testing, only the field) 

I choose advanced filter > Superior or equal to > 100

 

You do that for every other value and it will work fine.

 

 

- Quentin

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

 

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

 

@Colinu

 

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

 

- Quentin

Hardik
Continued Contributor
Continued Contributor

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

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.