Advanced Conditional Formatting on a Chart

Hi Phillip,

Thank you for reaching out. It is not currently possible to have Advanced Metric Conditional Format as Chart Color. As of now, the Basic Conditional Formatting option is compatible with charts, however. What I can do is submit an enhancement request to allow Advanced Metric Conditional Formatting as Chart Color. Would you like me to go ahead and create this enhancement request?

Thanks,

Mike

Hi Mike,

thank you for your fast reply. That would be a great enhancement I think, to visualize the data even nicer for the customers. Please create this enhancement request for me.

Best,

Phillip

Hi Phillip,

Great, thanks for your idea! I've gone ahead and created the enhancement request. Any potential updates regarding this matter will be posted in here.

Regards,

Mike

I would like to be able to format by comparison like a special colour in a bar graph to draw attention to the highest value.

Hi Geoffrey,

Thanks for your feedback. I'll consider this a vote for this idea considering your suggestion fits within the confines of available features in the Advanced Conditional Formatting section. As such, I've added you as a Client in favor of this enhancement in our internal task.

Regards,

Mike

Hello,

Thanks for the knowledge. actually, I am an assignment help provider but sometimes I would love to do some gardening.

Thank you Mike.

Geoffrey Feldman O;brian

Hi Geoffrey,

You're welcome.

Regards,

Mike

Two things I have noticed about basic conditional formatting on charts. First, it appears that you can have conditional formatting in your table but not in your chart if you so choose but that you cannot have conditional formatting in a chart without doing so in the table. Two, it appears that the special color chosen for the chart has to be the same color for the table. Please correct me if I am missing something.

Geoffrey Feldman O;brian

Hi Geoffrey,

If you don't want conditional formatting in the report itself, but still want to display the chart there are several methods to accomplish something similar to conditional formatting on charts themselves, though different charts vary in specific options. If you bring a Metric into the Color section on the Vertical Column chart for example, you can change the color based on automatically set bounds and a color scheme of your choosing, or by a range or center value:

This is how you would go about adjusting the look of a chart by itself.

Ultimately though, this is an enhancement request to add a feature to apply advanced conditional formatting options in the chart series settings, which is indeed not a current possibility. Please open a new trouble ticket if you have any further queries regarding this.

Thanks,

Mike