Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ttaa4455
Frequent Visitor

Blank cells in Table visual

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?

1 ACCEPTED SOLUTION
bcdobbs
Super User
Super User

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.



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

View solution in original post

3 REPLIES 3
Ilaria_1
New Member

non ho capito. posso avere una delucidazione?

ttaa4455
Frequent Visitor

Thank u! It worked 

bcdobbs
Super User
Super User

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.



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.