month slicer not filtering visual

Question

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

anonymous · Answer

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

kfschaefer · Answer

i am getting this error:&nbsp;

anonymous · Answer

kfschaefer&nbsp;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.&nbsp;

eric_zhang · Answer

kfschaefer
What is the data type of PowerBIData[month] and DateQry[month], please provide more details like simplified data from both tables.
&nbsp;
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 · Answer

I got the Slicer to work, however the results are not what I expected.&nbsp; 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).&nbsp; FYI my data consist of two rows of data, each row is a total for the Year(s) 2014 &amp; 2015.&nbsp; 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.&nbsp; 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?&nbsp;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.&nbsp;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.&nbsp;&nbsp;Does anyone know of a good working example where the date table is used and the matching data is in the Main Data table?&nbsp;&nbsp;

Forum Discussion

month slicer not filtering visual

5 Replies

Related content

Time Filter Slicer

Slicer Not Filtering Visuals as Expected

Slicer for filtering several columns

Black slicer apper when change Visual

List Slicer Visual Issue