Forum Discussion
Conditional formatting: no data bars option
Hi Arul
While creating an example for you, I found that the field has to be aggregated for data bars to be an option under conditional formatting:
However, after switching to aggregated values and adding the data bars, I removed the aggregation and the data bars remained. Guess that's a workaround.
Thank you for your interest!
For what field in the list are you looking for? Can you also share the datatype of that particular field?
Thanks,
Arul
Hi Arul
While creating an example for you, I found that the field has to be aggregated for data bars to be an option under conditional formatting:
However, after switching to aggregated values and adding the data bars, I removed the aggregation and the data bars remained. Guess that's a workaround.
Thank you for your interest!
Bless you! I struggled to find a solution and hoped they didn't remove 'data bars' in columns when everything was rearranged/restructured in the core...went column to column to ensure everything was set to 'SUM' in my data table, but for whatever reason, at the visual/element level, it still showed as don't summarize...toggeled it and voila...data bars were back. 🙂
Thank you. Thank you. Thank you. I would have never dug into this and found a solution, but for your post. Thanks again!
Missing bars:
 
Toggled SUM and the world was good again:
 
 
