Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
northshorehiker
New Member

Multiple copies of visual, each filtered by date relative to slicer

Hi there--

 

I'm looking at using the "at Timeline" visual from Pragmatic Works to show eight days worth of status logs. I'd like to select a single date in a slicer and have the top visual display data for the selected date, visual #2 to display data for one day after the selected date, visual #3 for two days after the selected date and so on... 

 

I managed to create a dynamic column which contains the number of days between that row's date and the date selected in the slicer, but using that column as a visual-level filter doesn't seem to override the existing filter to show all start / end dates. (These columns are used in the visual, and so can't be removed from the visual-level filters.)

 

Is there any way to make this work?

1 ACCEPTED SOLUTION
v-frfei-msft
Community Support
Community Support

Hi @northshorehiker ,

 

As we know, the data in calculated column is not dynamic based on the slicer value. So it is hard to achieve your goal. Here I create a sample for your reference as a workaround.

 

1. Cretae a slicer calculated table.

 

Slicer = CALENDARAUTO()

2. Create a measure as below and make the visual filtered by the measure.

 

Measure = var _sele = SELECTEDVALUE('Slicer'[Date])
var _date1 = MAX('Table1'[Date])
return
IF(_date1>=_sele && _date1<=(_sele+7),1,0)

 

 

Capture.PNG

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

1 REPLY 1
v-frfei-msft
Community Support
Community Support

Hi @northshorehiker ,

 

As we know, the data in calculated column is not dynamic based on the slicer value. So it is hard to achieve your goal. Here I create a sample for your reference as a workaround.

 

1. Cretae a slicer calculated table.

 

Slicer = CALENDARAUTO()

2. Create a measure as below and make the visual filtered by the measure.

 

Measure = var _sele = SELECTEDVALUE('Slicer'[Date])
var _date1 = MAX('Table1'[Date])
return
IF(_date1>=_sele && _date1<=(_sele+7),1,0)

 

 

Capture.PNG

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.