Forum Discussion
Solved
Replace Blank Matrix Cells with Text
I've created a matrix visual that acts as a training matrix, showing for each of our employees their status on each course (completed, not started) etc. Not every employee has the same courses assig...
Never mind I figured it out, needed to create a measure that would take the current value or replace blanks in the matrix:
Course status =var CurrentItem = SELECTEDVALUE('Learning_Records'[Course status])return IF( ISBLANK(CurrentItem )||CurrentItem = "", "Not required", CurrentItem)
Never mind I figured it out, needed to create a measure that would take the current value or replace blanks in the matrix:
Course status =
var CurrentItem = SELECTEDVALUE('Learning_Records'[Course status])
return IF( ISBLANK(CurrentItem )||CurrentItem = "", "Not required", CurrentItem)