How to add icons to dates

[Anonymous]

Hello!  I'd like to add basic icons to my due date column, but I'm not sure where to start.

My columns I have are: due date, load 1 complete date, load 2 complete date, qa date, delivered date

I'd love to have three icons:

- a red circle next to the due date when the date is in the future (wanting to use the today function)

- a yellow circle when the due date is within a week of today

- a green circle when the other 4 columns have a date in them

Thanks in advance for your help!

[selimovd]

Hey @Anonymous ,

this you can do with the conditional formatting icons. Check the following tutorial:

Native and Custom KPI Icons in Power BI - YouTube

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

I knew I needed conditional formatting, I just don't know what code I should put in a measure to get those icons.  Can you help with that?

[FrankAT · Accepted solution]

Hi @Anonymous ,

take a look at the following link:

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

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)