Please tell me how to replace characters in the report

[Tome_05]

Is there a way to replace characters in a Power BI report?
When I checked the query from the data transformation, there was no whitespace in the query, and there was "blank" data when I displayed the data in the report.
Please let me know if there is a way to replace the whitespace character in the report.

thank you.

[Icey · Accepted solution]

Hi @Tome_05 ,

Go to Power Query Editor, check if there are any "null".

To prevent this, replace "null" with "" like so:

Best Regards,

Icey

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

[amitchandak]

@Tome_05 , Blank may come because your dimension table(1 Side Table) is missing the values that are present in the fact (Many Side). The way to check is plot key from both side on table visual (not summarized)  and check for blank