Blank cells in Table visual

[ttaa4455]

Hi,

I have a table called "Team_Names" with 2 columns: "Full_Name" and "Team_Level"

I then have my main table that also has "Team_level" and is connected based on that. 

I am trying to create a visual table with a column from the Main table "Team_level" and the column "Full_Name". However when I create this Table visual some of the "team_levels" are not assigned to a name and just comes out as empty in the table, instead I want to say "open". How can I do that?

[Ilaria_1]

non ho capito. posso avere una delucidazione?

[ttaa4455]

Thank u! It worked 

[bcdobbs · Accepted solution]

Do all the team names exist in Team_Names but with blank full names?

If so use Power Query to replace null values with "Open" and then only use team names and full names from that table (we call it a dimension).

If they don't all exist you'd have to do some more work in power query. Roughly... 

1) Duplicate main table.

2) Remove all columns except for

team name.

3) Remove duplicates.

4) Merge join this onto your original name table.

5) Expand the column you get to retrieve full names.

6) Replace nulls with "Open".

7) Set your original name table to not load.

😎 Recreate joins with new table.