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 there,
Is there a way to change the color of one data point on a scatter chart? For example, I want the average project cost firmwide to be purple and the other project costs to be blue. I have been able to add an index and use that as filter but sometimes, there are so many data points that it doesn't show up. Is there a way to get that average project cost to always appear? Maybe a measure or some kind of formatting? Thanks for any assistance!!
Solved! Go to Solution.
@djoellet , I have used measure-based conditional formatting to color the scatter dot, You can modify that to use a categorical variable if needed
Scatter Visual with quadrants conditional formatting: https://youtu.be/IPMViiZjMeA
How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...
@djoellet , I have used measure-based conditional formatting to color the scatter dot, You can modify that to use a categorical variable if needed
Scatter Visual with quadrants conditional formatting: https://youtu.be/IPMViiZjMeA
How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 41 | |
| 39 | |
| 37 | |
| 29 | |
| 24 |
| User | Count |
|---|---|
| 122 | |
| 110 | |
| 83 | |
| 69 | |
| 68 |