Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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....
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
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
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
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
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