Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

blank cell

Hello,

Table visual has a few blank cells in a column

Is it possible to replace the blank cell with some text ?
I would like to know if this is possible on the table visual rather than doing this in the model.

 

Thank you

Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    7 years ago

    Hi Anonymous ,

     

    I’m afraid you need to create a measure or replace the blank in Power Query to implement it. There is no option of the visual to replace values directly in the report view.

    1. Create a measure
    Measure = IF(ISBLANK(MAX(Table13[Sale Price])),"No Values",SUM(Table13[Sale Price]))

     

    1. Replace values in Power Query

    Right click null -- > Replace Values…

    Best Regards,

    Xue Ding

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support
    7 years ago

    Hi Anonymous ,

     

    I’m afraid you need to create a measure or replace the blank in Power Query to implement it. There is no option of the visual to replace values directly in the report view.

    1. Create a measure
    Measure = IF(ISBLANK(MAX(Table13[Sale Price])),"No Values",SUM(Table13[Sale Price]))

     

    1. Replace values in Power Query

    Right click null -- > Replace Values…

    Best Regards,

    Xue Ding

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.