Chart: Make "Text on Data Point" invisible by condition doesn't work

[guyvermeiren]

Hello,

I have a linechart where I want to hide all results earlier than "Today's Monthnumber".

I selected "Text on Data Point" and it works fine if I use a condition for "Background Color" but not for "Text Color" (my text keeps appearing). (see example in enclosure)

When I switch to "Text on Axis" the condition for "Text Color" works perfect. (see also in enclosure)

I really would like to make this work with "Text on Data Point". Can anybody give me the solution to my problem.

Thanks.

Kind regards,

Guy

[#2]

Can you use the if-statement in the dimension? In this way also only the data from the current month will be displayed.

[guyvermeiren]

Thanks,

We are using this (calculated dimension) as an alternative method but then the chart only shows the months as calculated in the dimension.

Kind regards,

Guy

[Anonymous]

Hi Guy,

Did you check if both field have the same format?
The best way to check this is to make 2 text boxes

1.
=(Num(COPA.Period)

2.
=Num(Month(Today()))-1

This should return the same format, if not, that is the reason why it doesn't work.

[guyvermeiren]

Hello Dennis,

They are both the same format, that's also the reason why the condition works for "Background Color" and also when use "Text on Axis".

There's really something strange going on.

Thanks anyway.

Kind regards,

Guy

[#6]

I'm using QV9 and the "Values on Data Point" with your condition on "Text Color" works as you expect.