Instead of adding a single color at the end of the Sparkline, we could make one that shows whether the last value is higher or lower than the one before, or even display the maximum values, by taking the following steps.
- In order for the end of line indicator to change color, we need to make the calculation that we can see in the following screenshot:
- Move this calculation to the Marks card, as follows:
- Edit the Color option, as follows:
- Format the title, by right-clicking and choosing Edit Title, as follows:
- Type ...
