topic Re: Dynamic Color Assignment for Sensor Data in Power BI Matrix in DAX Commands and Tips

Dynamic Color Assignment for Sensor Data in Power BI Matrix

_halim — Fri, 25 Aug 2023 12:32:19 GMT

Hello,

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

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.

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

Re: Dynamic Color Assignment for Sensor Data in Power BI Matrix

lbendlin — Sun, 27 Aug 2023 00:31:43 GMT

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-Forum/ba-p/963216
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/1447523

Re: Dynamic Color Assignment for Sensor Data in Power BI Matrix

_halim — Mon, 28 Aug 2023 06:52:22 GMT

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.

Re: Dynamic Color Assignment for Sensor Data in Power BI Matrix

lbendlin — Mon, 28 Aug 2023 11:10:09 GMT

Read the first link again.