Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Calculate Measure Deviation

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%

 

Need Help
Tips and Tricks

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

      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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    There @EC3 ,

    Some data are created:

    v-yangliu-msft_0-1608253923944.png

    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)

    v-yangliu-msft_1-1608253923950.png

    3. Result.

    2020.12.181.png

    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.