I want to find a way to differentiate weekends from weekdays on a bar graph that spans a couple weeks. Ideally I would avoid having to make fake groups as I would need the solution to scale for multiple legend items. The ideal solution would have a grey highlight behind the bars for the weekends but I am open to other ideas.
Hi @Paul_Vandenberk,
Unfortunately, since conditional formatting is not an option on bar graphs, you would need to build some kind of grouping field that you can use at the group/color by field well value.
It could look something like this:
ifelse(extract('WK', {Date}) = 1 OR extract('WK', {Date}) = 7, 'Weekend', 'Week Day')
Let me know if you have any additional questions!
Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the Quick Sight Community!