Scatter plot + efficiency barrier

[elfunambolo83]

Hello,

I'd like to plot the graphic below on Power BI (Scatter plot + efficiency barrier), these are KPI coming from Earned Values Analysis (Cost performance index + Schedule Performance index).

Can I use an exist visual or need I to create a spicific one?

Thanks for support

Regards,

Giovanni

[elfunambolo83]

I added some columns and renamed the already present. How can I adjust the report with minimum modification of code?

CPI and SPI was not modified, I want only show other fields (Outage ID, Agreement, JCE and SCT) when I pass the mouse on the bubble.

Outage ID	Agreement	SPI	CPI	JCE	SCT
8831	QatarGas	1.04	1.3	$     255,765	$                        227,536

Thanks

Giovanni

[lbendlin]

You can add tooltips as needed

https://www.youtube.com/watch?v=4VXXkeFyLQ0

https://kerrykolosko.com/exploring-deneb-for-power-bi/

[lbendlin]

That would be a great scenario for a custom Deneb visual.

Please provide sanitized sample data that fully covers your issue.

[elfunambolo83]

The values are simply: only CPI, SPI and a value for the dimension of bubble

[lbendlin]

what are the rules for the color coding?

This is what I have so far:

[elfunambolo83]

Thanks for support.

I want to remove the line from 1st to 3rd quadrant. How can I do it?

Regards,

Giovanni

[lbendlin]

You can edit the Deneb code and remove the related rule entry. see attached.

[elfunambolo83]

Thanks.

I'd like to have the bubble size in proportion with how big is the Value, like in the Bubble charts visual.

How can I set it?

Regards,

Giovanni

[lbendlin]

See attached.

[elfunambolo83]

Thanks a lot, in which part of code is defined the size of circle and the threshold?

[lbendlin]

It's specified as part of the encoding