Basic question: Want my slicer to display more values than are used in the data table?

[kellywr]

Hi, I have what is probably a very simple question.  I have a list of values:

Activity Types

Running

Jumping

Swimming

Biking

Skipping

And a data table of people doing the activities:

Name	Activity Type
John	Running
Samantha	Running
Kevin	Swimming
Mary	Jumping

As you can see, not all values of my Activity Types are used in my data table (Biking and Skipping don't appear in my data table).  I want a slicer that contains ALL the options from the Activity Types table, not just the ones appearing in the data table.  This is for various reasons mainly concerned with UX.  How do I do this?

Thank you for any help!

[kellywr]

Thank you!!  My relationship was wrong.  That works now!!

[audreygerred]

Hello! Do you have a table added that has all of the activity types? If not, add that, then join it to your data table. In your slicer, grab activity type from the activity type table. It will show all of the values regardless if there is a match or not.

Here is an example - Test is not an actual category that is in my fact table, but since the field in the slicer is coming from the dimension table, all options are available.

If I select test, the visual below it with count just blanks out:

[Greg_Deckler · Accepted solution]

@kellywr Use the Activity Types table or create it using an Enter Data query. Ensure that there is a single direction relationship between that table and the data table. Activity Types table (1) -> (*) Data table.