Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a Bar Chart with "Show Total" checkbox selected for my dimension.
Total info is correctly displayed but bar color is the same of the rest of columns .. How can I set a specific color for this Total column?
"Total color" from Colors Tab is not being used ..
Thanks,
T
I've found this way to do it
if(Dimensionality()=0,color(2)) in Background color Expression column
Although this does not clarify me why "Total Color" from Colors tab is not being automatically applied ..
Hi,
Have you tried Multi Color from Colors tab in chart properties?
If not give it a go and let us know if this work.
Regards,
Gabriel.
Hi, also trying to set a fixed color for the Total bar in QV10..
Already tried if(Dimensionality()=0, LightRed()) on the Expression -> Background Color but it doesn't work.
Really simple on a table but not working on the chart.
Any ideas?
Try something like:
if(match(MyDim, concat(distinct MyDim ,',')),color(1), color(2))
Replace MyDim with the name of the dimension you use in your bar chart
Nice one, it works!
Thanks.