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?
User | Count |
---|---|
16 | |
15 | |
14 | |
12 | |
11 |
User | Count |
---|---|
19 | |
16 | |
14 | |
11 | |
9 |