I want to apply a sequential class on my hierarchical dimension of layer on my visual map chart. The problem is that I haven't found a way to change the color of the sequential class that is imposed. So I looked for a solution and I came across a post from an employee who explains that it is not possible to change the color of the basic sequential class and that it is necessary to go through a color by expression with the following expression:
So I would like to implement this expression on my 2 hierarchical dimension layers. However, the expression quoted above does not allow to do it for a hierarchical dimension. So I tried to do an OR or XOR to apply it on the 2 hierarchical layers, but it doesn't work.
Do you have any idea how to apply the sequential class on the 2 hierarchical dimensions? (Take into account that the measure is the same for the 2 dimensions)