Forum Discussion
Automatic drill by slicer
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
1 Reply
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
