slicer does not show all values

[hxkresl]

Slicer doesn't show all possible values in table. How to show all values available in table on the slicer, even if that value is not connected to data in other tables?   I want the slicers to affirm the existence of all application names.

 My AppName slicer missing value: SnickerDoodle.  Instead blank().

pbi file is here https://www.dropbox.com/s/ah4nhuatvz3ji7i/bidirectional.pbix?dl=0

DDL, See highlighted, that the AppName SnickerDoodle exists.

CREATE TABLE Alerts (
AlertID int,
AlertName varchar(100),
ApplicationName varchar(50),
IssueStartTime datetime,
ResolutionTime datetime, 
DateKey int,
SeverityID int)

INSERT INTO Alerts (AlertID,AlertName,ApplicationName,IssueStartTime,ResolutionTime, Datekey, SeverityID)
VALUES 
(160922, 'Can''t login', 'Shapeeze', '2017-05-08 12:00:00.000', '2017-05-23 18:00:00.000', '20170508', '1000'),
(160923, 'Screens freezing', 'Shapeeze', '2017-05-29 12:00:00.000', '2017-06-03 10:00:00.000', '20170529', '1002'),
(150319, 'Errors Submitting Forms','Shapeeze', '2017-05-23 06:00:00.000', '2017-05-29 13:00:00.000', '20170523', '1001'),
(210522, 'Server down', 'Napson', '2017-05-01 03:00:00.000','2017-05-01 23:00:00.000', '20170501', '1002'),
(210525, 'Updates failing', 'Napson', '2017-05-30 03:00:00.000','2017-06-10 12:00:00.000', '20170530', '1002'),
(120311, 'Customers Being Misrouted', 'Strikeone','2017-05-15 16:00:00.000', '2017-05-19 09:00:00.000', '20170515', '1001'),
(120313, 'Customers Deadending', 'Strikeone','2017-04-15 16:00:00.000', '2017-06-12 09:00:00.000', '20170515','1002'),
(043293, 'Calls dropping', 'VeritVru','2017-04-12 03:00:00.000', '2017-04-12 09:00:00.000', '20170412','1000'),
(043297, 'Static on calls', 'VeritVru','2017-04-27 03:00:00.000', '2017-05-06 09:00:00.000', '20170412','1002'),
(043298, 'Reboot', 'VeritVru','2017-05-27 03:00:00.000', '2017-05-27 04:00:00.000', '20170527','2222'),
(043299, 'Upgrade', 'VeritVru','2017-04-30 00:00:00.000', '2017-04-30 01:00:00.000', '20170430','1111');

CREATE TABLE Severity (
Severity varchar(20),
SeverityID int)

INSERT INTO Severity
VALUES
('Sev 0', 1000),
('Sev 1', 1001),
('Sev 2', 1002),
('Informational', 1111),
('Maintenance', 2222);

CREATE TABLE Alert_Application (
AlertID int,
ApplicationID int);

INSERT INTO Alert_Application
VALUES
(160922, 1001),
(160923, 1001),
(150319, 1001),
(210522, 2000),
(210525, 2000),
(120311, 3000),
(120313, 3000),
(43293, 4000),
(43297, 4000),
(043298, 4000),
(043299, 4000);

CREATE TABLE Applications (
ApplicationID int,
AppName varchar(20))

INSERT INTO Applications 
VALUES
(1001, 'Shapeeze'),
(2000, 'Napson'),
(3000, 'StrikeOne'),
(4000, 'VeritVRU'),
(5000, 'Snickerdoodle');


CREATE TABLE LOB_Application(
ApplicationID int,
LOBID int);

INSERT INTO LOB_Application 
VALUES
(1001, 888),
(2000, 888),
(3000, 777),
(4000, 777),
(5000, 999);

CREATE TABLE LOB (
LOBID int,
LOBName varchar(20));

INSERT INTO LOB
VALUES
(888, 'BigLeague'),
(777, 'LeftArch'),
(999, 'LittleLeague');

CREATE TABLE Agent_LOB (
LOBID int,
AgentID int)

INSERT INTO Agent_LOB
VALUES
(888, 111),
(777, 222),
(999,333);

CREATE TABLE AgentSite (
AgentID int,
AgentSite varchar(20),
Country varchar(20),
CountryID int);

INSERT INTO AgentSite 
VALUES
(111, 'Dublin', 'Ireland',234),
(222, 'Hyderabad', 'India',876),
(333, 'Prague', 'Czech Republic', 921);

CREATE TABLE Countries (
CountryID int,
Country varchar(20))

INSERT INTO Countries 
VALUES
(234, 'Ireland'),
(876, 'India'),
(921, 'Czech Republic')

[hymieho · Accepted solution]

The .pbix file you pointed to in your dropbox does not include an AppName of "Snickerdoodle". Can you repost your model with the Snickerdoodle row added?

Also, your data model seems overly complex--3NF models (with a separate dimension table for everything) are not encouraged--try to make a single denormalized fact table. In fact with the bidirectional filters you have on and th 1:1 relationships, I think you essentially have just 2 tables anyway: (1) a date table and (2) everything else is one big table as far as PBI is concerned. 

[hxkresl]

Thanks for taking a look.

First - sorry, i thought that value had pulled in for this demo. For what it's worth, now it is pulling in Snickerdoodle https://www.dropbox.com/s/ah4nhuatvz3ji7i/bidirectional.pbix?dl=0 This demo file simulates my real world environment and I am trying to get at the root of an issue I have where not all values are in the slicer. In real life model am finding that unless I use bidirectional relationships, the data is correct but not all values showing up in slicers.   When i use single direction relationships the data is skewed but all values appear in slicer.   I thought I had found the trigger for the problem, but I didn't since as the table now contains SnickerDoodle, it is appearing on the slicer too.

Second: thanks for feedback on model.  At some point I would remodel it but this is first time direct pull from CRM.  If the reporting requirements get complex enough, I will make the case for a model.  As right now the report is not so complex I cannot justify the cost of investing in SQL tabular model source.