Highlight columns up to current phase in project in table visual

[CaveOfWonders]

Hi community,

Would appreciate your help. I have attached a link to a pbix file with some dummy data loaded to make this easier.

Link

I have this table visual in Power BI which has a list of projects and a column at the end which indicates which phase each row is in.

The desired outcome I would like is shown in the image below. I want the columns to be highlighted up to the stage which they have reached. 

Forgot to Add: If possible, it would be great to highlight the current stage in a darker shade.

Note: This needs to be in a Table visual

I have tried a few different measures but ends up as a dead end each time.

Thank you in advance.

[CaveOfWonders]

Thank you so much v-xiaotang this has worked a charm. 

[v-xiaotang · Accepted solution]

Hi @CaveOfWonders 

use conditional formatting, 

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

https://www.myonlinetraininghub.com/conditional-formatting-in-power-bi-tables-and-matrices

Since it's conditional formatting on columns, you need to do it for each column. I created the following measures and set them up for the first 3 date columns.

Measure1 = 
var _phase= MIN('Table'[Phase])
var _curph=1
return IF(_curph<=_phase,"#FAE5D3")

Measure2 = 
var _phase= MIN('Table'[Phase])
var _curph=2
return IF(_curph<=_phase,"#FAE5D3")

Measure3 = 
var _phase= MIN('Table'[Phase])
var _curph=3
return IF(_curph<=_phase,"#FAE5D3")

for example, click Date column - Conditional formatting - background color 

result

I only set it up for the first three date columns.

for more please see the sample file attached below

Best Regards,

Community Support Team _Tang

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

[CaveOfWonders]

Thank you v-xiaotang. I will test this to see if I can get it to work. Seems like it might.