Conditional Formatting

[Grace_Guo]

Hi I was wondering if I am using the conditional formatting correctly?

My goal is essentially be a table checklist. From the excel reference source, there is either a date for when an activity is completed or not, and I wanted to display (on the Power Bi) a check mark for whenever the source spreadsheet has a date in the column.

My question is the value set are dates, not numbers, and under the conditions can only do percentages or numbers. If I do the following:

Then am I really saying if the reference cell is blank then display an X, and if there is a date in the cell display a checkmark?

Any help and suggestions is greatly appreciated 🙂

[TheoC]

Hi @Grace_Guo 

Create a new calculated column: 

Date Check = IF ( ISBLANK ( Table[Reference Cell] ) , 0 , 1 )

From there, you should be able to use the new Date Check column as the basis of building your Table Checklist.

Hopefully I have understood the issue correctly. Apologies if I haven't.

Theo 🙂

[Grace_Guo]

Hi @TheoC Thanks for the advice! I think you understood what I am looking for. I am new to power bi and learning as I go. So would I make the new column on the transform data querie? 

[TheoC]

Hi @Grace_Guo 

That's good to hear. And don't stress, we all started our journey the same way! 🙂

In terms of the Calculated Column, you won't need to use Transform Data (also referred to as Power Query). Rather, if you go to the main ribbon, you should see a button called "New Column".  If you click that and copy / paste the code I wrote, you should get what you are wanting. 

Let me know if that makes sense k otherwise can organise screenshots and a couple of step throughs.

Thanks heaps,

Theo