Table to show an icon when the project end date is within the date range of that column...

[djj1994]

Hi all,

I want to produce a table (mockup below), where I have:

• Rows: Project name
• Columns: Date ranges (quarters e.g. Q1 2023)
• Icons:
  • To show where the "end date" of the particular project is within that particular date range column (one per project, based on the project end date from my dataset)
  • Coloured by "project status" e.g. in progress, completed

Any help would be greatly appreciated, thanks!

[v-zhangti]

Hi, @djj1994 

Sample data:

Q = "Q"&QUARTER([Date])&" "&YEAR([Date])

Measure = IF(SELECTEDVALUE('Table'[Project status])="Completed","Green",IF(SELECTEDVALUE('Table'[Project status])="In progress","Orange"))

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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