States on dynamic filter

Hi!

We are working with dynamic filter to manage the graphics. In one graphic we are showing 2 different kind of topics each of one has one specific target, for example Machine no.1 has a target of 75% machine no. 2 has a target of 85% . And we want to set up states according to the machine, for example if i select the machine number one and the result is lower than 75% then the bar has to be on another color, and if i select the machine number 2 if the result is lower than 85% the bar has to be in other color.

Thanks in advance for your support!

Hi Diana,

Thank you for contacting Dundas support

To accomplish this requirement you can use the state property in Dundas BI. Please setup a state with measure values and the condition. In condition you can give as machine name and threshold value . Based on the states Dundas BI will give different color for bars and you can change the color in the property panel. Please see the screenshot for you reference

Machine 1 target value less than 75 shows in red color

Machine 2 target value less than 85 shows in different color

Please let me know if this works for you

1 Like