Deneb: Use Calculation For Window Frame

[JayWee]

Hi All,

Can i please find out whether does vega lite support calculation values in the Frame?

Please advie.

Thanks in advance.

Jay

[Akash_Varuna · Accepted solution]

Hi @JayWee According to the Vega-Lite documentation, frame expects an array with two elements:

• The start of the frame relative to the current data object.
• The end of the frame relative to the current data object.

the frame property does not support dynamic expressions or calculations parseInt(datum.MvgAVG) * -1 .

It requires static numeric values or null. 
For more details on transformations please check this documentation Vega-Lite Window Transform documentation.
If this post helped please do giev a kudos and accept this as a solution
Thanks In Advance

[Akash_Varuna · Accepted solution]

Hi @JayWee According to the Vega-Lite documentation, frame expects an array with two elements:

• The start of the frame relative to the current data object.
• The end of the frame relative to the current data object.

the frame property does not support dynamic expressions or calculations parseInt(datum.MvgAVG) * -1 .

It requires static numeric values or null. 
For more details on transformations please check this documentation Vega-Lite Window Transform documentation.
If this post helped please do giev a kudos and accept this as a solution
Thanks In Advance

[JayWee]

Hi Akash,

Thanks for the rapid reply.

In that case, is there a method to replace the start frame using slicer that you know of?

Thanks

Jay

[Anonymous · Accepted solution]

Hi @JayWee,

Thank you for reaching out in Microsoft Community Forum.

Thank you @Akash_Varuna  for the helpful response.

Please follow below steps to replace the start frame using slicer;

1.Vega-Lite's frame property only accepts static numeric values (e.g., [-1, 1]) — it cannot use dynamic expressions like parseInt(datum.X) or respond to slicers.

2.Slicers in Power BI cannot dynamically control frame in a Vega-Lite spec — it’s not interactive in that way.

3.To achieve dynamic behavior, perform the calculation in DAX or Power Query and pass the result to Vega-Lite.

4.Alternatively, use native Power BI visuals for dynamic rolling windows or frame-based calculations.

Please continue using Microsoft Community Forum.

If this post helps in resolve your issue, kindly consider marking it as "Accept as Solution" and give it a 'Kudos' to help others find it more easily.

Regards,
Pavan.

[JayWee]

Thanks Pavan.

I've just started using Power BI and Deneb, so still trying to work out how stuff works.

Will give the DAX calculation a go and figure out how to incorporate into Deneb.

Thanks both for the advice.

Jay