Assigning Value instead of Blank in Slicer

[shhafiz]

Table Relations and Blanks Options

I am facing similar problem as discussed in the link above. To summarize, because of unmatched value in relationship, a (Blank) option appears in slicer. I want this Blank value to show an assigned text on slicer so it's visually more appealing to the user.

One option is to have a dummy row in one table for each of the unmatched in the other, but that would introduce invalid data in one table and this is something I don't want.

Thanks.

[v-sihou-msft]

@shhafiz

Currently, you can only create calculated column to assign custom text value for not mached values, like: 

Column = IF(ISBLANK(RELATED(Table[col])),"not match", RELATED(Table[col]))

Regards, 

[shhafiz]

@v-sihou-msft

In order to use related, the two tables must share this column right? If so, this doesn't apply to my case as the two tables are related by a different column. The values of these columns are coming as (Blank) for rows which are not matched in the other table.

[parry2k]

@shhafiz can you share sample data and screen shot? What @v-sihou-msft proposed, should work.

[shhafiz]

@parry2kI the above error message. I double checked the spelling of the Table and Column names. I am assuming it's the second part of not have relationship is causing the problem.

[parry2k]

first and foremost, are these two tables related with each other, doesn't matter what column the are related on? Yes or No?

Are you adding new coloumn or measure?

[shhafiz]

@parry2k

Yes, these two tables are related.

I am trying to add a new column. 

[parry2k]

Can you share the sample data of two tables and related you set between those tables?

From your errors, it looks like 'Event Type' Column doesn't exists in 'Reviwed Resources' table. 

It will easier if you share sample data. Thanks