Hi @smilingjohn, for the circle you can add a measure with value as =Chr(11044)
And in color text expression you can use your expression, instead of the qmem://<bundled>/BuiltIn/... use the rgb color code for each one or name the colors:
=Pick(Match(
if(Aggr(Count(DISTINCT Network),Network)>0,
if(aggr(count(Distinct if([Sub-Department]=Sub_Dep and
WildMatch(Category,'*N12*')>0,ID)),[Sub-Department])>0,'R',
if(aggr(count(Distinct if([Sub-Department]=Sub_Dep ,ID)),
[Sub-Department])>0,'G','B')),
if(aggr(count(Distinct if(WildMatch(Category,'*N12*')>0,ID)),Departments)>0,'R',
if(aggr(count(Distinct ID),Departments)>0,'G','B'))
)
,'G','R','Y','B')
,RGB(0,192,0),Red(),Yellow(),Blue()) // RGB code or color function
