Forum Discussion
Helper IVNeed help - Scatter plot - how to colorize all data above a certain value?
Hi Guys,
I have a scatter plot with Days on the x-axis (going from 1-365), and TPC on the y-axis.
Days are created from "Day = RELATED('Calendar daily'[DayNoOfYear])"
In the below I have Days as dont summarize and and TPC as dont summarize. As summarizing makes no sense. I would like to color all data points above >10.000 red.
When I try to do this through format --> data colors, I can only choose to change one data point at a time as can be seen in the second image.
I can also choose to put my y-axis (TPC) into legends and not summarize my y-axis. This still gives me the same data plot, however, now I have a million colors and the issue is the same.
How do I choose to colorize a range - in this instance all data points >10.000 colored red?
Thank you for all help. 🙂
What version of Power BI desktop are you on?
Can you see this option to conditionally format the colour?
If so, this blog might help with transparency...
Dynamically Changing the Color Transparency in Power BI | Sandeep Pawar (pawarbi.github.io)
Or this blog with just colour using field value:
Conditional formatting by field value in Power BI - Power BI Docs
4 Replies
- KerKol
Power Participant
What version of Power BI desktop are you on?
Can you see this option to conditionally format the colour?
If so, this blog might help with transparency...
Dynamically Changing the Color Transparency in Power BI | Sandeep Pawar (pawarbi.github.io)
Or this blog with just colour using field value:
Conditional formatting by field value in Power BI - Power BI Docs
IrwinHi,
The newest version I assume. Company should keep it up to date.
Yes I see that field - didnt really notice it before now. I will try to read your material and see if I can solve it. Thanks 🙂
- Irwin
Dude... that was totally easy. I have it solved already. Not sure how I could miss that field.
Thanks alot! 🙂
- KerKol
You're welcome 🙂