Calculate Measure Deviation

[Anonymous]

How can I show the increase or decrease in scroller bar 

I have a column with the % of "afectacion" tis is calculate base on Failure Time and TND (Time Available) 
We have as a objective a 3% of afectacion and I nee to show in this scroller if the %afectacion of eahc month is higher o lower than 3%
but all of them are showing positive even when they are lower than 3%

[Anonymous]

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.

[Anonymous]

Hi  @Anonymous ,

Not very clear,Could you please provide me with more details about your issue or expected output?

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.

[Anonymous]

What I want to achieve is this

December Affecation = 3%
November Affectation = 5%


The objective is 3%

December = 3% so its ok it should be green

November = 5% so it should display red indicator and a 2% of difference

I need to display this difference in the Scroller Visual