Dynamic Color Assignment for Sensor Data in Power BI Matrix

[_halim]

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

 

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[_halim]

Hi, thank you for your response but I reached the max count of characters with a table (instead of screenshots). I don't know why.

[lbendlin]

Read the first link again.