Forum Discussion
Changing bar colour based on a Bar graph
Hi! Is it possinle to chnage the colour of the bars in a bar chart based on a condition where keep all the bars for example blue if its before current month and red if its after current months. S...
Hi Anonymous ,
As I know, if you want to use conditional formatting on bar color, you can't add field in Legend. You could refer to my sample for details.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Step 3 it does not allow me to make the meassure with that option.
Sorry, Its suppose to be a New Column and not New Measure as this is categorical in nature.
Hope this solves your issue.
I created both meassure and cloum but the issue is I am unable to add it to the legend on my clustered bar chart.
Please provide a sample workbook to work on as i'm able to do with my data set.