Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Conditional Formatting for reporting- Shapes

cstafford
8 - Asteroid

I have a report that uses basic conditional formatting for three specific conditions; cells are Red, Yellow or Green based on the condition. Does Alteryx have the ability to use a specific shape with color based on the condition versus using a background and text color. 

3 REPLIES 3
binuacs
21 - Polaris

@cstafford You can change the color of the Columns or rows based on the condition in the Table tool. The Column rules and Row rules will allow you to specify conditions and formatting.

 

https://help.alteryx.com/20223/designer/table-style-rules

 

 

binuacs_0-1677796150580.png

 

Below are some posts that will help your use case

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Basic-Table-formatting-tool/td-p/54518...

 

 

cstafford
8 - Asteroid

I use this today but I am curious if I can insert a colored shape. For example, is the condition is GOOD, I color the cell green, however, I would like to use a green circle. I see their is a formula check box at the bottom of the row rules, is their a formula to add shapes?

Christina_H
14 - Magnetar

There's a solution you could try on this post: Solved: Inserting Conditional Shapes/Icons in Cells Simila... - Alteryx Community

It imports the shapes as images before including them in the table, so you would need to calculate the condition, import the correct shape, then create the table.

Labels