I have recreated a problem I'm consistently having to workaround. Wondering if anyone has a way of fixing this.
In the attached example you will see that I have set colours for my cat dimension as grey and black (using an expression). I also need the chart to remain static even with a selection on Group. However, when I make a selection on Group, the colours revert to the default. I'm assuming this is because I have essentially filtered out the data that sits behind these Groups, therefore no cat, therefore no colours.
Hi there - I had a requirement where the client wanted to specify specific RGB codes for each of the customer groups in their data. I did this by providing a spreadsheet to them with the client names and blank columns for the colour codes. Once this was populated it was pulled in and used, the code for it is a bit like what I have posted in this community thread: