Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
10 | |
6 |