Forum Discussion
Auto filtering based on values provided
Hi.
I have a problem with a line chart.
I want to automatically filter time based on values provided by sensors. For example:
Sensors provided values since 14:30 to 21:30 at 21st October 2023 and for them i have a slicer, which slices x-axis to time 14-22 etc
And i want to automatically slice chart by values in a day
My table
| Id | Date | Sensor 1 | Sensor 2 | Sensor 3 | Sensor 4 | Shift |
| 1 | 21-09-2023 14:30 | 45 | 654 | 654 | 122 | 14 |
| 2 | 21-09-2023 14:31 | 85 | 666 | 112 | 231 | 14 |
| 3 | 21-09-2023 14:32 | 44 | 545 | 244 | 548 | 14 |
7 Replies
This should work automatically. Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?
I tried something like this, but it filters the sensor values and i only want to apply the shift value as a filter
CALCULATE(VALUES('table'[Licznik cefla_1]),FILTER(FILTER('table','table'[sensor1] > 0),'table'[shift]))That code makes little sense. Can you describe, in business terms, what you are trying to achieve? Maybe even show the expected outcome?
The thing is that data is automatically collected 24/7, even when sensor values are 0, that means when i slice my graph by day values start from 00:00 to 23:59
I want the graph to start and end on the blue lines
