Automatic drill by slicer

[kchojnowski]

Hi,
I have slicer and chart in direct query mode.

I want to:

• show on chart 2 months if i took last 2 months in calendar slicer
• show on chart 7 days if i took last 7 days in calendar slicer
• show on chart 2 years if i took last 2 years in calendar slicer
• etc

Got relative calendar. I put on it Date create. Im porting data from sql server. DOnt have calendar table. Also i have made hierrarchy with days, months and years (bin).

Can someone help me? Now i have something like this:

Best regards

[v-yuta-msft]

Hi kchojnowski,

Do the fact table has relationship with the date or calendar dimension table. If they have, you can simply drag the date column into report level filter and use advanced filter to achieve this. Please refer to: https://docs.microsoft.com/en-us/power-bi/power-bi-report-add-filter.

Regards,

Jimmy Tao