Forum Discussion
Slicer feature
Question #1: Can I use the same slicer for several talbes?(So I don't need to have huge number of slices)
Answer:
You can use the same slicer for the two reports. You can add the following disconnected table to the Data Model (use the Enter Data feature for that), and let's call the table "ReportSwitch"
ID | Message
-------------------
1 | "Last 7 days"
-------------------
2 | "Previous week"
Now, assuming you already have two measures [Last 7 days] and [Previous Week] you can create a new measure:
Dynamic Measure = IF ( MIN ( ReportSwitch[ID] ) = 1 , [Last 7 days], [Previous Week] )
Next, create a slicer and feed it with the column Message of table ReportSwitch, and feed the new measure [Dynamic Measure] to your visual's Values.
Question #2: Can I use one slicer to all the report or I need to use him each page?
Answer:
You cannot use the same slicer to affect for all the pages. Each page is controlled by its own slicers.
Hiope it helps,
Gil