Forum Discussion
fahadkhan
1 year agoFrequent Visitor
Matrix visual Hierarchy and conditional color based on overall color
Hi everyone, I have a simple usecase for matrix visual i want to display. I have a table with Project, Project group, Team lead, task and status color in one table. so based on the heir...
- 1 year ago
Hey fahadkhan
TEst this one, bit lengthy tho:coloring = var currentProject = SELECTEDVALUE('Table'[Project]) var currentStatus = SELECTEDVALUE('Table'[Task Status]) var isTaskLevel = HASONEVALUE('Table'[Task]) var delayedRedOnes = COUNTX( VALUES('Table'[Project Group]), CALCULATE( COUNTX( VALUES('Table'[Project]), CALCULATE( COUNTROWS('Table'), 'Table'[Task Status] = "Delayed", REMOVEFILTERS('Table'[Task]) ) ), REMOVEFILTERS('Table'[Project]) ) ) var inProgressOnes = COUNTX( VALUES('Table'[Project Group]), CALCULATE( COUNTX( VALUES('Table'[Project]), CALCULATE( COUNTROWS('Table'), 'Table'[Task Status] = "In Progress", REMOVEFILTERS('Table'[Task]) ) ), REMOVEFILTERS('Table'[Project]) ) ) var completeGreenOnes = COUNTX( VALUES('Table'[Project Group]), CALCULATE( COUNTX( VALUES('Table'[Project]), CALCULATE( COUNTROWS('Table'), 'Table'[Task Status] = "Complete", REMOVEFILTERS('Table'[Task]) ) ), REMOVEFILTERS('Table'[Project]) ) ) var taskLevelCheck = SWITCH( TRUE(), isTaskLevel && currentStatus = "Delayed", "red", isTaskLevel && currentStatus = "In Progress", "yellow", isTaskLevel && currentStatus = "Complete", "green" ) var idk = SWITCH( TRUE(), completeGreenOnes > 0 && ISBLANK(delayedRedOnes) && ISBLANK(inProgressOnes), "green", delayedRedOnes > 0 ,"red", isTaskLevel, taskLevelCheck, "yellow" ) return idk
speedramps
Super User
1 year agoCreate a measure like this
Please click thumbs up because I have tried to help.
Then click [accept solution] if it works
Project group colour =
var mylist =
CALCULATETABLE(
VALUES(yourdata[Status]),
ALLEXCEPT(yourdata,yourdata[Project Group]),
yourdata[Status] <> "Complete"
)
RETURN
IF (COUNTROWS(mylist) > 0, "Red", "Green")