blank cell

[Anonymous]

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

[v-xuding-msft · Accepted solution]

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.