Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In the background expression for color after setting few slices as red, green, amber based on a condition, I would like all other pie slices to have the color from the pallette. - color tab - instead of one color for all new pie slices. basically for all new pie slices as the pie chart grows I want it to take colors from the color tab from the pie chart instead of having one color for all new pie slices.
There is option from pallet custom colors to Default using in built check box from section called "Colors"
Hi anil, I want the default colors to take impact after few conditions are applied in the background color. Can you please share where the exact check box or setting is that will work along with the background color expression.
Also I have set this expression in the background color of the expression and not the dimension. I hope i am correct here. (Please confirm if I have added in the right place. The expression checks for dimension values and sets particular RGB color and this is placed in the expression background color -please confirm placing of expression is correct
Actual question - Please share the exact setting you are mentioning that will work along with the background color expression that is set for few slices only. Want default colors to take over after that. Otherwise share syntax that will help with the same
Please reply where exact setting is
Anil where is the exact setting to have default colors along with the background conditional expression I have set. Once expression is over it should take default colors. Can you please gt back to ke with the exact setting or syntax. That would be helpful
Hi Trail,
Try like this:
=if(Product='A',red(),if(Product='B',Green(),color(RowNo())))
Br,
KC
Refer attached
Br,
KC
Thank you Jyotish will check and get back. Do you have a solution for Unable to pass the task at publisher level while reading SharePoint list-require solution urgently
This is regarding reading a SharePoint list at publisher level and I am getting the task as fail. Please read through the post and give me a solution.
Hi jyotish, is there a way to make color(row()) persistent colors? Persistent check box is working only for few.
Jyotish, the color row no is not giving persistent colors. On drill down it becomes blue. Any solution here.