i am struggeling with a simple line chart. It shows revenue over month - so "Month" would be one dimension. It has two expressions. The one calculates revenue for the current year. The other calculates revenue for the previous year. All no problem.
What i want - and until now couldnt get to: I want the line representing the current year to have a specific color (lets say, red) and the line representing the previous year to have another specific color (lets say, gray).
Can anyone help and explain how this can be done in SENSE ?
Left-click the line chart while in edit mode. The properties of the chart will show up on the right side of your screen. Click on Appearance --> Colors and legend --> And deselect the option where it says auto colors ON. Select "By expression" in the menu box that appears, and underneath that you can enter in a expression that can customize the color of the line chart.
I dont want to have anything selected - i would like to use two expressions, one pointing to current year, the other to previous year ... when i do this i seem to lose the option to color code the lines...
In 11 it was easy as you could just set a color directly on every expression...
Hi, I've seen a few issues around applying specific colours to charts in Sense and wanted to offer an alternative solution. This works well if there are a limited number of dimensions you want to display (e.g. last four years data with each year coloured in gradients of gray with the current year in red, or sales broken down by product category with a total sales amount also displayed in specific colours)
This can be achieved using a synthetic dimension
1. Create the dimension as a synthetic dimension using ValueList. Note: define the dimensions using a useful reference (e.g. 'Current Year') rather than 'Dim1' since this will be displayed in the popups!
=ValueList('Dim1', 'Dim2', 'Dim3', 'Dim4')
2. Create a single measure with the value to be shown for each Dimension