Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Replace cell value in Power BI Matrix Visual cell value

I have a matrix visual as shown below. When i drag my values inside this visual , i see that some of the cells i.e

A->feb

A->mar

are blank as shown in the image below (current output) . This is not a measure so i cannot add 0 as shown in many other example. I created a separated column with the following function  

BLANK = IF(ISBLANK('Table'[Value]),"not scan",'Table'[value])

but its not working. I want the matrix visual to show me the values as shown in the image expected output. 

How can i achieve it?

 

 

Need Help

3 Replies

  • mariussve1's avatar
    mariussve1
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Hi,

     

    Strange, can you please try this:

     

    Measure =

    Var scan = SELECTEDVALUE ( Table[value] )

    Return
    IF ( scan = BLANK (), "not scan", scan )

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      mariussve1  Thank you for you kind reply. I tried your solution but it did not work. I think the problem is how to tell the formula that the cell between  (A-->F) within the matrix is empty? Another thing is value is Text and not numeric so not sure if the measure will work.