- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

One date slicer from several queries/fields
Hello,
I have a Power BI report with three visuals that I'd like to apply one date slicer to.
The three visuals are populated by three separate fields/queries and each of these have a date column which display dates but these dates are different in each as they cover different stages of the project.
Is it possible to create a date slicer from these three different date ranges and apply it to the three visuals?
Many thanks.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

In Power Query, create a new date "Fact Table" from the three original tables, which contains only date (deduped).
Go back to Desktop, Model View, and set up relationships between the Fact Table and each of the three other tables.
Create a date slicer using the new Fact Table.
Providing the interactions are correct on your report tile, selecting a date from the new slicer should update everything else.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

I think they can have different names.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thanks, yes I'm just starting now and seems to let me link them regardless of title.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thanks @AndrewPF
When I go to set up the relationships, do the date columns need to be the same name across all of the tables to be connected or can I link date columns regardless of their names?
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

In Power Query, create a new date "Fact Table" from the three original tables, which contains only date (deduped).
Go back to Desktop, Model View, and set up relationships between the Fact Table and each of the three other tables.
Create a date slicer using the new Fact Table.
Providing the interactions are correct on your report tile, selecting a date from the new slicer should update everything else.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-18-2024 12:30 PM | |||
09-15-2024 08:24 PM | |||
08-06-2024 07:48 PM | |||
09-26-2024 07:58 PM | |||
09-13-2024 07:14 PM |
User | Count |
---|---|
141 | |
115 | |
83 | |
63 | |
48 |