IF column value is true, add a column in the table

[Anonymous]

Hi all,

I have some sanity checks which are orange if there is a mismatch between 2 columns. I would like that, if a sanity check is yellow, then two other columns appear next to it so I can see what the issue is. Also a button to display such columns would be ok

[PhilipTreacy]

Hi @Anonymous 

Fair enough, but I said there wasn't enough information provided.  You didn't provide any data and I didn't know that you were setting the color that way. In your reply you've referred to #colorcode in a column, so you have created a column of hex colors? 

Regards

Phil

[PhilipTreacy]

Hi @Anonymous 

There's not enough information to give you an answer here.

You can't check the color of a cell in a visual using code so you'd need to check a value in these cells.

If say Orange = 1 and Green = 0 then to create these other 2 columsn you want from the Orange cell, how to know what to put in these columns?

You can't have a button to click that makes these columsn appear.  The columns will be there either with data in or without data.

You could also use a measure ( this is preferable ) rather than use a column.

Please suply some data and examples of the result you expect.

regards

Phil

[Anonymous]

Why I can't check the color of a cell? If I have used the #colorcode as a result and the conditional formatting gives that color, I can reference to it such is if(column="#colorcode ", create and add a column to table, dont create nor add column)

Also, I think I found my own solution. If there is no way to do what I said in the first row, I will create a button where every time you toogle it, it will hide the old graph and show another hidden graph with the old columns + the new one of interest