How to use single slicer to affect all other slicers

[ApurvaKhatri]

I have three different date columns that I want to connect with a single date column.

Suppose I select Date1 slicer and select year 2016 in a date hierarchy, all the other date slicers in the page should show up the year 2016. I sthis possible and How?

[ApurvaKhatri]

I have a date column groupingDate which has dates. I need to get every Monday date and every friday

[ApurvaKhatri · Accepted solution]

I have a table LeaseHistory with columns Principal, DownPayment, Taxes, Late Fees,Warranty, Post Date, LeaseType

Another Table FeeHistory with Fees, PostDate, FeeType,PostDate.

I want to connect these two tables on postdate as I need sum of principal and sum of fees to be affected by a single postdate.

For e.g. If I select year from post date I should get sum(Principal) and sum(Fees) from single slicer on postdate.

Thanks,

Apurva Khatri

[TomMartens]

PoHey,

just create a separate Calendar table, in the modeling pane using the DAX function CALENDAR(), there are many examples available.

Then create 2 relationships, using the date column from the Calendar table on the one-side of the relationship and the Post Date of your existing tables on the many-side.

Use the Calendar table for the slicer and for other viusals.

I guess this site will get you started: daxpatterns.com/time-patterns

Hopefully this gets you started

Regards

Tom 

[ApurvaKhatri]

Hi.. Thankyou for your reply. That works..!!!!

[v-huizhn-msft]

Hi @ApurvaKhatri,

Actually, I am still confusing about your requirement, the three different date columns in one same table or different tables?

Slicer is used to filter rows, the three slicers can affect each other automatically if there columns come from one table. I post an sample table including three date columns. If this sample does not explain what you want, could you please share your sample data or more details for further analysis?



You can click "Edit interactions", when the funnel button is highlighted, which means the slicer is affected by the selected one. So the slicers can affect others as follows.

 select 2016 in slicer1In 2016 year, select January

Best Regards,
Angelia