
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Create ur dimension as a master dimension; then edit it and attribute the colors u want to every value:
Please refer to this video:

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Make a duplicate, edit the app, re-publish it.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
H
ow did u construct ur second dimension?
The one that has the 1,2,3 and 4 values?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
count({<Phase={'1'}>}distinct(right([Name],9)))
and my dimension is:
XY3

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
