blank value for data that does not exist in the relationship

[gofgabriel]

Hi guys,

I wonder if it is possible to replace the blank value with something else for data that has no reference in the relationship.

If it was in SQL I could do with CASE, but bouth data is extracted from different systems (ServiceNOW using REST and Orion using SQL query ). I know I can register the missing data in ServiceNow, but I must have to treat anyway.

Any tip?

** For those who want to know how I made the shaped map, I got the global from a JSON file.

FILE LINK

[v-xuding-msft]

Hi @gofgabriel ,

Maybe you could create a calculated column using the function of IF to replace the blank values.

Column = IF(financials[Country] = BLANK(),"Canada",financials[Country])

Or you could try to filter out the blank values in visual level filter.

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.

[gofgabriel]

I tried it before but didn't work out and I have to show those data.

The problem is that the main table is not complete, so when I make the relationship, some data is represented as blank. Power BI should give us a way to rename easily the BLANK fields.