Forum Discussion
Conditional formatting based on a pushstreaming value in a dashboard
Hello everyone,
our company wants to use conditional formatting for visualizing target performance comparison in a real time-data Dashboard.
So if a value of a pushstreaming-Data gets over or under +-5% (bandage percentage 5%) the font of that value should be visualized for example in red.
I know that this is possible with conditional formatting, but this is only possible with a value I type in the conditional formatting window. But the conditional formatting should be based on a dynamic value, i.e. a dataset value. The target value comes from the OPC Server. So it is a realtime data and dynamic. Does anybody has an idea how to solve this?
Best regards
2 Replies
Hi. If you have your streaming dataset with the necessary columns to capture the conditional formatting values then its a matter of creating measures. Create a measure for the value and a measure for the color. Remember you can conditional format by a measure/column. You can return inside of a measure the hex code of the color or some numbers that you will use for rules in the conditions (e.g 1 for red, 2 for green, etc)
Hope that helps,
