Calculate Measure Deviation

There @EC3 ,

Some data are created:

1. Create calculated column.

Column 2 =
IF('Table (2)'[Column]>0.03,-('Table (2)'[Column]-0.03),+('Table (2)'[Column]-0.03))

2. According to the characteristics of scroller

Place [date] in category, and visually display the content

Place the column in measure absolute to display the absolute value of

Place column2 in measure deviation to show that any change (positive or negative) is deviation from the final measurement (absolute value of measurement)

3. Result.

You can downloaded PBIX file from here.

This is the link of related content for your reference:

https://www.sqlshack.com/scroller-visual-for-stock-price-movements-in-power-bi-desktop/

https://blog.pragmaticworks.com/power-bi-custom-visuals-scroller

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.