Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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 |
I want the graph to start and end on the blue lines
And the graph is made of
x-axis: date
y-axis: sensor1,sensor2,sensor3
This should all be automatic if your Dates table controls your fact (sensor data) table. Do you have a Dates table in your data model?
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
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
That code makes little sense. Can you describe, in business terms, what you are trying to achieve? Maybe even show the expected outcome?
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 6 | |
| 5 | |
| 5 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 16 | |
| 8 | |
| 7 | |
| 7 |