Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I want 2 dashboards: one for results from the last 7 days and one for the previous week.
So, to prevent using 2 reports I want to use slicer.
Can I use the same slicer for several talbes?(So I don't need to have huge number of slices)
Can I use one slicer to all the report or I need to use him each page?
Hi @ranbinho,
In addition, you can see product team is working on the implementation tactics about allow slicer to filter all report page visuals. You can see: Allows Slicers to apply to all Pages of a Report. Currently, we can use Report level filter pane as a workaround.
Best Regards,
Qiuyun Yu
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
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |