Announcements
You can succeed best and quickest by helping others to succeed. Join the conversation.
cancel
Showing results for
Did you mean:
Contributor III

## Line Chart Color

hello guys,

i tried to change the colors in my line chart, but it I couldnt.

XY3 is my dimension and 1,2,3,4 is a counted number.

Like: count({<Phase={'1'}>}distinct(right([Name],9)))

i wanted to change the colors for the counted numbers.

1 Solution

Accepted Solutions
MVP

I see:

1) if u have 4 measures; you MUST create the 4 Measures as master measures and assign color to each measure there (only and unique way to do it)

2) transform ur chart :

from : 1 dim , 4 measures

to : 2 dims, 1 measure

sthing like :

dim 1 :XY3

dim2: Phase

Measure : count(distinct(right([Name],9)))

or

count({<Phase={'1','2','3','4'}>}distinct(right([Name],9)))

(depends on ur data)

and then u can:

a) assign the color for each value when u create ur Phase dimension as a master dimension

b) color by expression:

if(Phase='1',red(),

if(Phase='2',green() ...

Hope this helps

Omar BEN SALEM

8 Replies
MVP

Create ur dimension as a master dimension; then edit it and attribute the colors u want to every value:

Contributor III
Author
i cant because its already published
Specialist

Make a duplicate, edit the app, re-publish it.

Contributor III
Author
it doenst work because iam not the app owner. i need a expresion to change it.
i tried to do something like that: if(XY3='KW1', Phase='1', red())
but all lines are red now. i wanted to give each line a different number.
thank you.
MVP

H

ow did u construct ur second dimension?

The one that has the 1,2,3 and 4 values?

Contributor III
Author
the 1,2,3,4 is no dimension. its a performance indicators:

count({<Phase={'1'}>}distinct(right([Name],9)))

and my dimension is:

XY3
MVP

I see:

1) if u have 4 measures; you MUST create the 4 Measures as master measures and assign color to each measure there (only and unique way to do it)

2) transform ur chart :

from : 1 dim , 4 measures

to : 2 dims, 1 measure

sthing like :

dim 1 :XY3

dim2: Phase

Measure : count(distinct(right([Name],9)))

or

count({<Phase={'1','2','3','4'}>}distinct(right([Name],9)))

(depends on ur data)

and then u can:

a) assign the color for each value when u create ur Phase dimension as a master dimension

b) color by expression:

if(Phase='1',red(),

if(Phase='2',green() ...

Hope this helps

Omar BEN SALEM

Contributor III
Author
Thank you Omar. It worked!!!
Tags
Community Browser