Forum Discussion

cepiolot's avatar
cepiolot
Frequent Visitor
9 years ago
Solved

Timebrush default time selection

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 filt...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    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,

     

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

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,