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

Pie chart Remove white lines

Hi All,

 

I have a weird question, may you could help me. I would like to set a RAG pie chart. Once the value is in a range, it should show Red, Amber or Green. It's working fine, the only issue, once I have same colour neighbours, it adds an extra white line, what I cannot remove. If I have 10 slices with 10 different colours, it's not appear, but once I have same colours it does. 

 

 

dexter2424_0-1599470291411.png

As you see in the pictures, I don't have the white line between amber and green, but I have between greens. Have you got any idea how to remove the lines?

1 ACCEPTED SOLUTION

@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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

5 REPLIES 5
amitchandak
Super User IV
Super User IV

@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

https://powerbi.tips/tools/report-theme-generator-v3/



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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% --->Amber

C-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. 

 

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?


Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved. 


If you found this post helpful, please give Kudos. ?


I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query. 


www.excelwithallison.com

@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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

AllisonKennedy
Super User III
Super User III

How have you created the chart? The lines are showing that each of those is a different segment of the pie, and so when the same color is next to each other, Power BI add that in to delineate the different Categories.
What are you trying to graph? Maybe a gauge visual would work for what you need?


Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved. 


If you found this post helpful, please give Kudos. ?


I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query. 


www.excelwithallison.com

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors