Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
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?
Solved! Go to 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
@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
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.
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
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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 133 | |
| 88 | |
| 85 | |
| 68 | |
| 64 |