Advanced Conditional Formatting on a Chart

Phillip Lassen shared this idea 10 months ago
Idea Logged

Hello,

is saw the possibility to use conditional formatting for charts:

https://www.yellowfinbi.com/resources/forum/yfforum-conditional-formatting-for-bar-charts-thread-154912

I have tried to use the alert type advanced, but as soon as I switch from basic to advanced I cannot see the conditional formatting option in the chart view.

Is it even possible to use advanced alert types for chart formatting?

Best,

Phillip

Comments (10)

photo
1

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

photo
1

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

photo
1

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

photo
1

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.

photo
1

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

photo
1

Hello,

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


_________________________________

24*7 Assignment Help in Australia

photo
1

Thank you Mike.

Geoffrey Feldman O;brian


gfeldman@comdist.com

Computer Distributors Inc.

Tel: 787-793-3434 ext.204

www.cdipuertorico.com

https://www.facebook.com/CDIPR/

https://es.linkedin.com/company/cdi-puerto-rico

b14275483b722865f9e193bff97367c3

From: Yellowfin Support [mailto:support@yellowfin.bi]

Sent: Monday, August 6, 2018 6:15 PM

To: Geoffrey Feldman

Subject: New Comment in "Advanced Conditional Formatting on a Chart"

photo
1

Hi Geoffrey,

You're welcome.

Regards,

Mike

photo
1

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


gfeldman@comdist.com

Computer Distributors Inc.

Tel: 787-793-3434 ext.204

www.cdipuertorico.com

https://www.facebook.com/CDIPR/

https://es.linkedin.com/company/cdi-puerto-rico

b338dca08bba9c0e0fe425d931cec1af

From: Yellowfin Support [mailto:support@yellowfin.bi]

Sent: Monday, August 13, 2018 10:24 AM

To: Geoffrey Feldman

Subject: [Idea Logged] Advanced Conditional Formatting on a Chart

photo
1

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:

/Q2D2W4kpa08AAAAASUVORK5CYII=

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