Timebrush default time selection

[cepiolot]

I'm trying to get the Timebrush Visual from the Visual Gallery to automatically select the last two weeks of data to filter when the report is loaded. Originally, I used a visual level filter to filter time on a separate graph, however the timebrush and the visual level filter have proven not to work well together. Whatever I do, I cannot timebrush more than 2 weeks if the visual level filter is set to only display the last 2 weeks. For this reason, I wanted to get rid of the visual level filter enitrely and just have a default timebrush selection when the report loads. Is this possible?

Thanks,

Darcy

[v-sihou-msft · Accepted solution]

@cepiolot

When you add visual level filter, the context is limited to two weeks range only so that you can't select more that two weeks in slicer. However, it's not supported to set default selection for any type of slicer visual currently. For your requirement, you can create a calculated column column to tag if the date is within last 2 weeks. Then put the tag column into a slicer for selection.

IsWithinTwoWeeks =
IF ( Table[Date] >= ( TODAY () - 14 ), 1, 0 )

Regards,