Forum Discussion
Visualize current value with 52 week range data
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. A...
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
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.