cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LarsThomas
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
OwenAuger
Super User
Super User

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


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn

View solution in original post

6 REPLIES 6
bastik
Frequent Visitor

@OwenAuger  How do you hide a slicer?

@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.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-visuals#hide-and-show-visu...


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn
OwenAuger
Super User
Super User

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


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn

HI,

 

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

 

Regards 

Hi.

If I want to syncronize filters in OR logic  conjunction?

This worked great, thank you!

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.