Today I’ll show you how to highlight the minimum & maximum values on a line chart. This is very useful technique to show the lowest & highest values on the line chart. To get this working, I’ll use multiple expressions with a single dimension. I have also used Rank() & IF statement. I’m also providing the expression syntax.
Max Value : IF(Rank(SUM(Amount))= 1, SUM(Amount))
Min Value : IF(Rank(-SUM(Amount))= 1, SUM(Amount))
Ps: This technique won’t work with multiple dimensions. So you need to either use two dimensions or multiple expressions. Howeve, you can still use the grouped dimension.
I’ll demonstrate step-by-step process. Please contact me if you have any questions.
Just in case if you can’t watch the video from this site, you can use this link to watch from Youtube.
Thank you for watching. Happy learning.