cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LarsThomas Frequent Visitor
Frequent Visitor

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!

1 ACCEPTED SOLUTION

Accepted Solutions
OwenAuger Super Contributor
Super Contributor

Re: Combine two date columns in one filter - both dates are in the same table

Hi there,

 

There is a recent feature that allows you to sync slicers in groups, including slicers on different columns.

(see here)

 

  1. Create slicers on each of the Transaction Date & Settled Date columns (or whichever date-related column you wanted to filter on)
  2. In the Sync Slicers pane under Advanced Options, enter the same Group name for each slicer
  3. Then you can hide one of the slicers so the user just needs to control one.

 

Regards,

Owen



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

4 REPLIES 4
OwenAuger Super Contributor
Super Contributor

Re: Combine two date columns in one filter - both dates are in the same table

Hi there,

 

There is a recent feature that allows you to sync slicers in groups, including slicers on different columns.

(see here)

 

  1. Create slicers on each of the Transaction Date & Settled Date columns (or whichever date-related column you wanted to filter on)
  2. In the Sync Slicers pane under Advanced Options, enter the same Group name for each slicer
  3. Then you can hide one of the slicers so the user just needs to control one.

 

Regards,

Owen



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

LarsThomas Frequent Visitor
Frequent Visitor

Re: Combine two date columns in one filter - both dates are in the same table

This worked great, thank you!

Highlighted
sato89 Regular Visitor
Regular Visitor

Re: Combine two date columns in one filter - both dates are in the same table

Hi.

If I want to syncronize filters in OR logic  conjunction?

Guyakobov Regular Visitor
Regular Visitor

Re: Combine two date columns in one filter - both dates are in the same table

HI,

 

There is another option for the same resualt? like DAX?

 

Regards 

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 221 members 2,134 guests
Please welcome our newest community members: