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.
Appreciate your help. Thank you.
3 Replies
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.
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.
