Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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?
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 20 | |
| 11 | |
| 10 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 34 | |
| 31 | |
| 19 | |
| 12 | |
| 11 |