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.
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?
Solved! Go to Solution.
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)
Regards,
Frank
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)
Regards,
Frank
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |