I want to color a phase that has already finished with Matrix Visual

[Lopez0090]

There is a table that keeps track of the progress for each user.

Status is shown in Green for smooth, yellow for no change, and red for delayed.

This is visualized in the matrix visual on the right image.

So far so good, but we would like to furthermore be able to see the phase that has ended as shown in the figure below.

For example, I would like to add color to Steps that have already been finished, but I am having trouble achieving that.

If anyone has any good ideas, or knows of a better way to do this, please let me know.

If you have any questions about my request, please comment and I will respond as soon as possible.

Best regards,

Lopez

[amitchandak]

@Lopez0090 , For that you need to have some data for previous steps.  Create a separate Status and Status Num Table and then create a measure like

Steps= Count(Table[Status])+0

Final =

var _step =  maxx(allexcept(Table, Table[User]), Table[Status Num])

return

calculate([Steps] , filter(all(Status), Status[Status Num] <= _step) )

With help of above measure , you can do conditional formatting and icon conditional formatting

You can use another measure if needed

example

Color measure to be used in conditional formatting using filed values

Color Date = if(FIRSTNONBLANK('Date'[Date],TODAY()) <today(),"lightgreen","red")

Color Weekday = if(FIRSTNONBLANK('Date'[Weekday],blank()) in {"Sunday", "Saturday"},"lightgreen","red")
Color Weekday = if(weekday(max('Date'[Date]),2) >=6 ,"lightgreen","red")

If you need custom icon use unichar

example

/////Arrow
Arrow =
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
TRUE(),
_change > 0, UNICHAR(9650),
_change = 0, UNICHAR(9654),
_change < 0, UNICHAR(9660)
)

/////Arrow Color
Arrow color =
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
TRUE(),
_change > 0, "green",
_change = 0, "blue",
_change < 0, "red"
)

[Lopez0090]

@amitchandak 

Thank you for your response!

Two Measure and Status tables were created.

Steps = COUNT('Table'[Status])+0

Final = 
var _step =  maxx(allexcept('Table', 'Table'[User]), 'Table'[Status Num])
return
calculate([Steps] , filter(all('Status'), 'Status'[Status Num] <= _step) )

However, even using the "Final" measure, I still get this display, what am I doing wrong?

If you don't mind, would it be possible to show us the actual image?