How to show all fields in a bar char even if there is no corresponding count

[Kashgar]

I have a table that lists all leadership principles an employee demonstrates and using this I created a horizontal bar chart to visualize the total counts of each principle that is in the table when you lookup an individual employee. My blocker, I want to visualize all potential principles (16), however, the bar chart will only show the principles for where there is a row in my table (see table example below). How can I visualize all potential principles if they only have 5 in the table? How can I visualize all 16?

This is an example of the table:

Column 1	Column 2	Column 3	Column 4
Are Right a Lot	Strength	Peer	Employee A
Frugality	Strength	Manager	Employee A
Bias for Action	Strength	Self	Employee A
Frugality	Strength	Peer	Employee A
Dive Deep	Strength	Direct	Employee A
Earn Trust	Strength	Peer	Employee A
Earn Trust	Strength	Manager	Employee A

Here is the current visual, but as you can see it will only visualize if there is a row with that principle in the table.

[David_Wong]

Hi @Kashgar,

You need to include all 16 principles in your dataset. Start with a dataset that contains all the 16 principles and create a left join with your existing dataset. You’ll end up with a dataset like this where some principles don’t have any value in your columns 3 and 4:

Column 1	Column 2	Column 3	Column 4
Are Right a Lot	Strength	Peer	Employee A
Frugality	Strength	Manager	Employee A
Bias for Action	Strength	Self	Employee A
Frugality	Strength	Peer	Employee A
Dive Deep	Strength	Direct	Employee A
Earn Trust	Strength	Peer	Employee A
Earn Trust	Strength	Manager	Employee A
Ownership	Strength

[Kashgar]

Hi @David_Wong Thanks for the solve. One follow up question, can you recommend an option for hiding the “null” value in the legend (see red outline)? If I click on hide it just adds a filter. Any tips?

[David_Wong]

Hi @Kashgar,

You can’t remove it without also removing the bars that don’t have any value.