Dynamic Color Assignment for Sensor Data in Power BI Matrix

Hello,

I have a table called "SensorenDaten_Import" (SensorData) that contains sensor values recorded every minute.

SensorData

Additionally, I have a table named "Farbvergebungsregeln" (ColorAssignmentRules) which defines target ranges for various sensor values. This table comprises 7 distinct ranges, each associated with 4 priority levels (represented by 4 different colors). These priorities are meant to determine the color based on the assigned range, and if a sensor value falls into multiple target ranges, the color with the lower priority should be applied.
Farbvergebung (ColorAssignment)

The complexity arises from the fact that the color assignment depends not only on a single sensor value but also on the duration during which the sensor value remains within a specific range. Your insights and guidance in effectively addressing this scenario would be greatly appreciated.

The entire process also needs to work dynamically, meaning that depending on the selected month and sensor, a corresponding color should be displayed.

I've been working on this for weeks and haven't made progress.

Thank you,
 
Halim