value shown blank over weekly slicer but correct value over monthly slicer

[Anonymous]

hello guys,

i have 2 tables, tax:

date	tax
7/1/2022	0.25
8/1/2022	0.265
9/1/2022	0.3

and date table :

date
7/1/2022
7/2/2022
7/3/2022
7/4/2022
7/5/2022
7/6/2022
7/7/2022
7/8/2022
7/9/2022
7/10/2022
7/11/2022
8/1/2022
8/2/2022
8/3/2022
8/4/2022
8/5/2022
8/6/2022
8/7/2022
8/8/2022

i made a relationship over the 2 tables with date as the common ground,

i have set a timeline slicer with date table as the date and when i set it on month, it gives me the correct value and works fine as shown in images below:

 but my profit loss report is based on weekly data so i have to give results everyweek but when i choose weekly it doesnt give me the correct value :

it only gives me the value when i select the week where "08/01/2022"is present for august

i know a work around is to just merge datetable with tax table and fill in tax number for everyday but i dont want alot of data 

any help?

[tamerj1 · Accepted solution]

Hi @Anonymous 

easiest and best practice solution would be to modify your tax table by adding more rows as to have the tax value for each date or simple add the tax value to your date table. 

[Anonymous]

@Jihwan_Kim @SpartaBI @amitchandak @daXtreme  @tamerj1 id appreciate your help