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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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

View solution in original post

5 REPLIES 5
amitchandak
Super User
Super User

@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/

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?

Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as 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 C

I work as a Microsoft trainer and consultant, 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

AllisonKennedy
Super User
Super User

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?

Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as 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 C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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