Color by Expression - Line Chart and Pie Chart

[hlines_usacs]

Hello,

I have a line chart and a bar chart in which I want to use the same expression to color.

Below is the expression and a screen shot of the two charts.

Is there a reason that they pie chart colors wouldn't work?

IF([Code] = '91'

,red()

    ,IF ([Code] = '83'

    ,blue()

        ,If(

 = '84'

            ,yellow()

        ,green()

                )

        )

   )

[agigliotti]

I'm using June 2017 version and it works fine using both RGB and colors.

Did you select color by expression and checked "The expression is a color code" in "Color and legend" settings ?

[hlines_usacs]

Yes, that option is selected.

[Neymar_Jr]

Hi hlines_usacs,

Can you please share the dimension and measure that you are using.

Regards,

Rajesh Thakur

[Lucke_Hallbergson]

An example from 3.2 SR4;

[shraddha_g]

Do you have anything else in that Dimension except Number.

Because in screenshot something is blurred before numbers

[hlines_usacs]

They are string values.

[shraddha_g]

did you use those actual values while comparing with Code field ?

[pradosh_thakur]

it seems to me like there is something wrong with where you are applying the expression. you need to check your measure too and make sure you use that back ground color of the dimension/expression. if possible share a sample document.

[hlines_usacs]

This is the measure I am using.

SUM({<[Fact Type]={'Financial'},[Code]={'91','85','84','83'}>}[Encounters])

[hlines_usacs]

Dimension:

[Code]

Measure:

SUM({<[Fact Type]={'Financial'},[Code]={'91','85','84','83'}>}[Encounters])