Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a dimension in pivot table which needs to be have different color codes based on the dimension value.
Eg:
If(Country = 'US','RGB(255,0,0)', If(Country = 'EU','RGB(0,255,0,)',RGB(0,0,255)')
The Background color in dimension works only for 1 color code and does not work for multiple if conditions. How can this be achieved.
@neerajthakur I did try using the conditions as you mentioned.
=if(num([Workload.Risk_Score],'#.##')=2.40,red(),blue())
It goes to Else Part.
Also, it is a dimension and I am not using any other calculation for this dimension.
Don't know what's happening would suggest you to try in a separate app using inline load.
Does all the values end with 0 in your case then try this expression
=if(num([Workload.Risk_Score],'#.#0')=2.40,red(),blue())
Share screenshot from Model Viewer of that field from Preview Pane, I want to see the Tags there, if it's not numeric then try making it using Num() or Num#()
Thanks for you response.
Does Vizlib not support this feature?
I´d rather use a pick
pick(Match(Country ,'US','EU','LATAM'),
RGB(255,0,0),
RGB(0,255,0),
RGB(0,0,255),
)
But Pick might work when the value is 2.4, 1.5 etc., but my requirement is that
if Score is GE 3.5 --> Green
if Score is between 2.5 and 3.4 --> Blue
if Score LE 2.4 --> Red
hi,
i guess column => [Workload.Risk_Score] is added as a measure i.e =sum([Workload.Risk_Score]) ?
if that so then try this
=if(column(NUMBER)=2.40,red(),blue())
make sure to write the correct column i.e column(1) or column(2)
format HEX codes as below
=if([Workload.Risk_Score]=2.40, Num#('#00FF00','HEX'), NUM#('#FFFF00','HEX'))
Hi @vinieme12 & @ajaykakkar93 . I tried both. It just doesn't work. Is it a limitation with Vizlib. This works with normal pivot table, but not with Vizlib.
Sorry, got confused by your example
It might, would suggest to raise issue with VizLib support.