Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register 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?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
16 | |
13 | |
12 | |
11 | |
11 |
User | Count |
---|---|
19 | |
14 | |
14 | |
11 | |
9 |