Forum Discussion

NorbertG's avatar
NorbertG
Helper I
2 years ago

Auto filtering based on values provided

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 ...
lbendlin's avatar
lbendlin
Super User
2 years ago

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?

  • NorbertG's avatar
    NorbertG
    Helper I
    2 years ago

    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]))
    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

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