Forum Discussion

tommeboy's avatar
tommeboy
Frequent Visitor
5 years ago

Date Slicer NOT filtering correctly ?

I've got 3 slicers, 2 behave correctly, but a Year slicer I have works fine when set to ALL, but will not filter my GROUP SWITCH when Years are selected ?  (see image) How do I get the GROUP...
Need Help
Arentir's avatar
Arentir
Resolver III
5 years ago

Hi tommeboy ,

it is difficult to answer without having access to the report. Are you able to share the model here?

tommeboy's avatar
tommeboy
Frequent Visitor
5 years ago

dim_client table
client_id,client_name,state
1,Client A,IL
2,Client B,CA
3,Client C,OH
4,Client D,CA

fact table
client_id,job_id,date,rev,hours,type
1,1,9/23/2020,44364,116,1
1,1,1/1/2021,44973,127,0
1,2,3/7/2020,53596,175,1
1,2,6/15/2020,7477,0,1
1,2,8/20/2020,0,155,1
1,3,8/20/2019,19594,117,1
1,3,11/28/2019,50113,197,1
1,4,2/1/2019,31001,173,0
1,4,5/12/2019,50331,73,0
1,5,4/7/2018,31980,200,0
1,5,7/16/2018,7134,78,0
1,5,10/24/2018,8164,104,1
1,6,2/1/2018,9486,115,1
2,7,3/15/2018,11721,99,1
3,8,6/15/2020,3283,118,0
3,8,9/23/2020,1575,69,1
3,8,1/1/2021,9581,20,0
1,9,3/7/2020,5818,115,1
2,10,11/28/2019,2263,163,1
4,11,8/20/2019,1328,150,1
2,12,5/12/2019,1893,33,0
2,13,2/1/2019,5196,45,0