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.
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
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |