Showing results for 
Search instead for 
Did you mean: 
gofgabriel Frequent Visitor
Frequent Visitor

blank value for data that does not exist in the relationship

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.



Community Support Team
Community Support Team

Re: blank value for data that does not exist in the relationship

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 Frequent Visitor
Frequent Visitor

Re: blank value for data that does not exist in the relationship

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

Reembolsos e Despesas.png

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. Smiley Frustrated

Helpful resources

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 179 members 2,056 guests
Please welcome our newest community members: