Forum Discussion
Date Slicer NOT filtering correctly ?
if this helps .. pretty simple data model
Hi tommeboy ,
it is difficult to answer without having access to the report. Are you able to share the model here?
- tommeboy5 years agoFrequent Visitor
Sample Workbook Sample Workbook
- tommeboy5 years agoFrequent Visitor
I posted a link to the example .. it's tiny
below are the 2 datasets (also tiny) just for example
dim_clientclient_id client_name state 1 Client A IL 2 Client B CA 3 Client C OH 4 Client D CA
fact tableclient_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
The data is super clean .. no blanks ect, so I know that's not the issue
It really comes down to the GROUP Calculated Column IS NOT respecting the YEAR slicer.
it does work fine for the other 2 slicers though (customer name and state) ? - tommeboy5 years agoFrequent Visitor
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