Visualize current value with 52 week range data

[dhirendra59]

Hello, I need help in creating a custom visual similar to the attached in PowerBI. Similar to stock price slider where we can see current value compared to rolling 52 weeks high and low value. 

Appreciate your help. Thank you.

 

[dhirendra59]

Thanks for your response. I see it is possible to do it in excel but would like to easily visualize without sparkline (similar to box plot)

https://www.youtube.com/watch?v=Pykhc3JLvAs

[BrianConnelly]

You could do it individually and use a scatter plot.  Would need to have an index for each date, a measure for the current, a measure for the max, and a measure to check the two are the same to be used in the color expression, e.g. if Blue then Blue and if not Blue then White.  Of course you would complete additional formatting.

[BrianConnelly]

Create a measure for your Max and Min with the 52 weeks.  Use a table and add sparklines to the measure that you are using for the 52 weeks.  Then add a marker for the hightest point.  Filter the table for the last 52 weeks.