Forum Discussion
Pie chart Remove white lines
- 6 years ago
dexter2424 , I think conditional formatting is not supported on pie.
You need tp check for custom visual
https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals
dexter2424 , this white line comes when you use details. When using legend usually there no lines. You can remove the details. Color should be based on theme or default
See if theme generator can help you in getting a different color
- dexter24246 years ago
Helper I
I'm not using details, that is empty in my piechart.
I have different categories, like A,B,C,D,E,F and there are percentages for them. If it's above 90% it should be Red, if between 75-90 should be Amber, and if less than 75%, than Green.
My boss would like to see if we have something in Amber or Red, and he doesn't like the white lines. I don't care so much about the lines, but he does, so that's why I'm trying to solve the issue.
So the Pattern is something like this
A-55% --->Green
B-88% --->AmberC-34% --->Green
D-22%--->Green
E-59% --->Green
F-11% --->Green
I have downloaded a PRO chart, where I could set the line for 0 value, but there is no option in the built in one, and the PRO version doesn't work in PowerBI app.
- amitchandak6 years ago
Super User
dexter2424 , I think conditional formatting is not supported on pie.
You need tp check for custom visual
https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals
- AllisonKennedy6 years ago
Community Champion
Without the white lines how will you know where category C starts and D ends? If you don't care about the relative value of each category and don't need to see what each a,b,c category name you could write a custom column formula that calculates the total value for each category and assigns to red amber or green. Then plot color in legend and value in values.
Otherwise you may just look at a traffic light reporting using matrix and icon s conditional formatting?