month slicer not filtering visual

[kfschaefer]

I created a Month Slicer, however, I will not filter the Resutls on the attahced Visual.  What Am I Missing?

[Seth_C_Bauer]

@kfschaefer Your missing a relationship. Or, your relationships in the model are not correct.

[kfschaefer]

i am getting this error:

[Eric_Zhang]

@kfschaefer

What is the data type of PowerBIData[month] and DateQry[month], please provide more details like simplified data from both tables.

What's in the DateQry? If this table is only used to look up date's correlated month name, add a column in PowerBIData

as

month = FORMAT(PowerBIData[DateColumn],"MMM")

And choose that column month in a SLICER should work.

[kfschaefer]

I got the Slicer to work, however the results are not what I expected.  I wan to be able to select a month and then display all Group Names/Brokers who have the renewal date for within the Selected date(month).  FYI my data consist of two rows of data, each row is a total for the Year(s) 2014 & 2015.  As you can see when I added the Month(Renewal) to the report I am now getting multiple rows per "Group Name" displaying duplicate data.  What do I need to do to allow my users to select 1 month (slicer) and see all totals for the Group Name where the renewal date is within the selected month?

As you can see When I use the ShortMonth from the DateQry it displays the selected month, however I need to user the Month and Renewal Month for the filter to refelect the selected month from the slicer.

I really am getting very confused on how to create a working Month Slicer that is sorted correctly numeric and return the correct results from the manage relationships.

Does anyone know of a good working example where the date table is used and the matching data is in the Main Data table?

[Seth_C_Bauer]

@kfschaefer That means you have a missing value in one of the tables that is not in the other of the two columns you are trying to create a relationship between.