- 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
Combine two date columns in one filter - both dates are in the same table
Hello,
So I have two dates in one table "Transaction Date" and "settled date". Everything works fine with my report, but I have to have two slicers to get the result that I want, and I always have to set both slicers with the exact same dates.
Is there any way I can get one filter/slicer that filters my selection two different date columns from the same table?
Thanks!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi there,
There is a recent feature that allows you to sync slicers in groups, including slicers on different columns.
(see here)
- Create slicers on each of the Transaction Date & Settled Date columns (or whichever date-related column you wanted to filter on)
- In the Sync Slicers pane under Advanced Options, enter the same Group name for each slicer
- Then you can hide one of the slicers so the user just needs to control one.
Regards,
Owen
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@bastik @Visibility of visuals is controlled in the Selection Pane.
Select the slicer, View > Selection, then click the eye symbol next to the slicer in the Selection Pane.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi there,
There is a recent feature that allows you to sync slicers in groups, including slicers on different columns.
(see here)
- Create slicers on each of the Transaction Date & Settled Date columns (or whichever date-related column you wanted to filter on)
- In the Sync Slicers pane under Advanced Options, enter the same Group name for each slicer
- Then you can hide one of the slicers so the user just needs to control one.
Regards,
Owen
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
HI,
There is another option for the same resualt? like DAX?
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi.
If I want to syncronize filters in OR logic conjunction?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This worked great, thank you!
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
Subject | Author | Posted | |
---|---|---|---|
03-14-2024 12:55 PM | |||
07-05-2024 12:14 AM | |||
03-26-2024 07:45 AM | |||
05-24-2024 07:52 AM | |||
Anonymous
| 12-29-2023 12:56 PM |
User | Count |
---|---|
121 | |
79 | |
47 | |
45 | |
36 |
User | Count |
---|---|
179 | |
89 | |
69 | |
47 | |
47 |