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.
Solved! Go to 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.
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.
if the value of pre-term-testing is less than 15 then don't show or colour white
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
Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.
Join this community-driven Power Platform digital event for unbiased support and problem-solving.
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.
Visit our Community Blog for articles, guides, and information created by fellow community members.