Forum Discussion
Custom background on scatter chart
Hello everyone,
I have a scatter chart built on a table made of these columns:
- Project name
- NPV
- Workload
- Risk
I would like to set a custom background made of 9 coloured areas, defined by thresholds that are in a table. For example, if thresholds are "500" and "2000" for Workload and "0,3 Mln" and "0,6 Mln" for NPV I would have these areas:
if [Workload] >= 0 and [Workload] < 500 and [NPV] < 300000 then "Yellow"
else if [Workload] >= 500 and [Workload] < 2000 and [NPV] < 300000 then "Red"
else if [Workload] >= 2000 and [NPV] < 300000 then "Red"
else if [Workload] >= 0 and [Workload] < 500 and [NPV] < 600000 then "Green"
else if [Workload] >= 500 and [Workload] < 2000 and [NPV] < 600000 then "Yellow"
else if [Workload] >= 2000 and [NPV] < 600000 then "Red"
else if [Workload] >= 0 and [Workload] < 500 and [NPV] >= 600000 then "Green"
else if [Workload] >= 500 and [Workload] < 2000 and [NPV] >= 600000 then "Green"
else "Yellow"
The result should look like the picture shown below. Does anyone know how to do this?
2 Replies
thomasss , I doubt you can have a background color like that. But you can color the bubble based condition
Power BI Customer to Retain, Scatter Quadrant -Segment in 4 quadrants based on Margin % and Discount, Use Constant Line- https://youtu.be/0k_C_E7YOQY
Good day
thomasss and amitchandak
Do you have any different solution about background?
I would like to create dynamic background, but I can't. I added text box with color, but this is static object.
