Forum Discussion
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 image
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.
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.
17 Replies
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 Preparations 1 a 0 b c 12 d 4 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
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)
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
