Grey chart colors - not able to ignore date selections

[espen31415]

Hi,

I have a dashboard showing debt balances per selected date.

I also have a chart showing the debt balance from that day and until maturity date.

I am not able to get the colors into the chart, other than the selected date...

I make selections like this:

Year: 2022

Month: Mar

Day: 31

CurrencyDate: 31.03.2022

And in my chart I have Date as Stack, I have currency-type as Area, and as measure I have this set analysis:

=Num(
Sum({<PaymentType= {'Balance'}
,_SecurityCategory= {'1'}
, [Security Year]=
, [Security Month]=
, [Security Day]=
, [Security Date]= {">=$(=Date(Min([Security Date])))"} >} $(vAmount_in_Local_or_USD))/1000000
, '# ##0,00M') 

Anyone has any idea how I can solve this? I have tried so many different combinations, nothing works.

I would like the chart to show colors as if I selected from 31.03.2022 and to the last date....

[stevedark]

Hi @espen31415 

Do you have a colour expression on your chart?

If so, what I expect is happening is that the set analysis on your measure is showing values outside of the natural selections. The colour expression probably doesn't have the same set analysis, so outside of the selected values is appearing grey.

What you therefore need to do is ignore selections when calculating the colours, which you can do with a set analysis set of {1}.

That's a bit of a guess as to what is happening, but it is certainly something that I have seen before.

Hope that helps.
Steve

Hope it helps.

Steve

[espen31415]

Hi Steve,

Thanks for the suggestion, i do use colour by dimension, the same if statemnt as I use in Area:

Do you see if this could be any reason for my color problems?

Br Espen

[stevedark]

Hi @espen31415 

The expression you have in the screenshot, is that the dimension code or is it the colour expression code?

The issue may be that you have too many data points in the chart. Can you try changing the dimension to month rather than date to see if that then works correctly.

Steve

[espen31415]

Hi Steve,

Sorry for my late response.

You are right about the amount of datapoints could be one of the reasons for those grey gaps.  I tried a solution adding "start of each month" in my set analysis, and then it seems to be all good.

However, I am not able to modify the colors by expression. It seems that if I choose by dimension, and select "Dimension 2" the colors are set by default.

If I choose to select excatly the same dimension, by it's name, the chart becomes grey..

Here is what I have in dimesions and measure:

If i try to use color by expression as below, it gets all yellow as if no dimension exists:

Regards

Espen

[stevedark]

Hi @espen31415 

Colours on multi-demensional line charts can be problematic.

Have you tried having a Master Dimension for the stack and then set the colours on the Master Dimension values and then drop it on the chart, selecting Color By?

Steve