Conditional formatting based on custom column value

[juliano_nunes]

I've created a custom column with 0 or 1 (true or false) values based on a condition (if a date column is null then this custom column receives 0, else it receives 1).

I want to display an icon on this custom column based on these 0 or 1 values, however I could only make it based on summarization.

What am I missing?

[v-yingjl · Accepted solution]

Hi @juliano_nunes ,

If you want to retain the custom column and apply icons on it, you can create a measure and apply this measure on the custom column:

Measure = IF( SELECTEDVALUE('Table'[date]) = BLANK(),0,1)

Or you can apply icons on the measure itself directly:

Attached a sample file in the below, hopes to help you.

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@juliano_nunes , Try to display data at the row level. if you do not have and unique ID column then you can add an index column and use it in visual, In that case, summarized value will same as like value

https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/

[juliano_nunes]

I have a text column with GUID values (unique), however when I do the steps to add the conditional formatting, I get this:

How can I confirm which column is the index without having to create another one?