topic Re: Auto filtering based on values provided in DAX Commands and Tips

Auto filtering based on values provided

NorbertG — Thu, 28 Sep 2023 09:03:01 GMT

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

Re: Auto filtering based on values provided

lbendlin — Fri, 29 Sep 2023 23:51:28 GMT

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?

Re: Auto filtering based on values provided

NorbertG — Mon, 02 Oct 2023 11:53:25 GMT

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

Re: Auto filtering based on values provided

NorbertG — Mon, 02 Oct 2023 12:38:44 GMT

I tried something like this, but it filters the sensor values and i only want to apply the shift value as a filter

CALCULATE(VALUES('table'[Licznik cefla_1]),FILTER(FILTER('table','table'[sensor1] > 0),'table'[shift]))

Re: Auto filtering based on values provided

lbendlin — Mon, 02 Oct 2023 15:29:51 GMT

That code makes little sense. Can you describe, in business terms, what you are trying to achieve? Maybe even show the expected outcome?

Re: Auto filtering based on values provided

NorbertG — Tue, 03 Oct 2023 06:14:32 GMT

I want the graph to start and end on the blue lines

Re: Auto filtering based on values provided

NorbertG — Tue, 03 Oct 2023 06:15:52 GMT

And the graph is made of
x-axis: date
y-axis: sensor1,sensor2,sensor3

Re: Auto filtering based on values provided

lbendlin — Tue, 03 Oct 2023 15:57:32 GMT

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?