LinkedIn
Twitter
I dont know why but when I set a table and able the cell visuzalization for a field, the pallete of colors that I setted dont apply properly.
It happens when Im pivoting a field in the table and the other field I used for the cell visualization doesnt have values to be compare in the pivoting.
When there is two values (VECI 1.0 - VECI 2.0):
When there is only one value (VECI 2.0):
Thank you for your help!!
Hi Angeru, unfortunately that is a current limitation of the cell visualization. It is not possible to define a start and an end of the range, so your colors will always map from lowest to highest value. If there only is one value in the data table (100%) they will still be mapped from lowest (red) to highest (green), so all of them are marked red.
I would suggest ditching the cell visualization and using conditional formatting instead.
Conditional formatting allow you to set a start and end of the range, so you can force 0 to be lowest and 1 to be the highest, with 0.5 as the center, regardless of the content in the data table.
Just make sure to turn of cell visualizations first, otherwise the conditional formatting will not show up.
Hope this helps!
