Color messing up when I add expressions

[hjm35055]

Hi!

So I have the following chart.  As you can see, there are not that many employees showing and it is repeating colors which should NOT be happening.

I believe the reason this is happening is because I have 3 expressions that are only "text as a pop-up".  These are needed for a custom pop-up label.

When I remove the 3 "text as pop-up" expressions, it works fine!

Anyone know a way to fix this and keep those expressions??

Thank you!!!

[vishsaggi]

Can you share a sample app with just this chart if possible? In the chart properties Colors tab what are the sequence of colors there ? Before and after the expressions?

[hjm35055]

Sample is attached.

[vinieme12 · Accepted solution]

Experiment by Creating a DUAL Expression and remove the other pop ups

example

DUAL(  TEXXT  & TEXT & TEXT , sum(whatever) )

[hjm35055]

Thanks! I got the dual expression to work.  The only issue now is that all the text is on one line.  Is there a way in the expression to add it to a different line?

My current expression is:

Dual(Name
&IF(IsNull(GetFieldSelections([Person Type])),[Person Type],'')
&IF(IsNull(GetFieldSelections(Position)),Position,''),
count({<[Skill/Trait]={'Logic, Deduction, & Reasoning'}>}Score))

I would like it to be:

Hermelinda Stollings

Employee

Thank you!

[vinieme12]

Dual(Name & cHR(10)

&IF(IsNull(GetFieldSelections([Person Type])),[Person Type],'') & chr(10)

&IF(IsNull(GetFieldSelections(Position)),Position,''),

count({<[Skill/Trait]={'Logic, Deduction, & Reasoning'}>}Score))

If you want 2 or more line spaces use repeat(chr(10),2)

Cheers

V