Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm trying to represent some values in a pivot table as linear gauges. I did that, but now I need to color each "Categoria / Marca" with an custom RGB that I have in an inline.
This is how the table actually looks:
The expression that I'm using in the "Segment" color is:
If($(vRegDemCat) = 2, Only({<Categoria_Marca>} RGB(R, G, B)))
I don't know what is wrong and why the dimensions aren't getting their colors.
Thanks a lot.
Kindest regards!
A set analysis expression creates one set per chart, not a set per dimension value. That's why your expression doesn't work. Perhaps this will do the job: If($(vRegDemCat) = 2, RGB(R, G, B)).
If not take a look at this blog post: Colors in charts
Hi, I have tried that and I didn't get any result, all I got is the same green for all dimensions.