Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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,
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |