Forum Discussion

SigmundVoid's avatar
SigmundVoid
Frequent Visitor
2 years ago
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...
Need Help
  • SigmundVoid's avatar
    SigmundVoid
    2 years ago

    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)
     
KEAlexander's avatar
KEAlexander
Helper I
2 years ago

In the query editor, you could use "replace values" (see the transform tab) in the Course status column to replace blanks with "not required". 

  • SigmundVoid's avatar
    SigmundVoid
    Frequent Visitor
    2 years ago

    This was my first thought but doesn't work in this case. There are no blank values in the course status column in the original dataset, only in the matrix. For example there are 30 training courses in total, but an employee might only be required to complete 20 of them. They have no record in the original dataset of the 10 courses they don't need to complete, and therefore have a blank value for these courses in the course status column in the matrix, where every course is shown whether an employee needs to complete it or not.