Add threshold to numeric point based on a measure from a linked data source

[Daniel_Kramt]

Hello,

I face the following problem: I am using numeric points (Chart: Indicator) in my dashboard. I would like to add a coloured threshold to the numeric point - but instead of using an absolute threshold (for example: green colour if value < 100), I want to build a threshold based on a measure from another (linked) data source.

See the following example with two linked data models: Model 1 and Model 2

My goal is to change the colour of Measure M.1 if it is below Measure M.2 to green and to red if it is above Measure M.2.

Thank you and best regards,

Daniel

[saurabh_sonawane · Accepted solution]

Hi,

To meet the above requirement we have to do following step.

Step 1 =create a new calculate measure in story

step 2 = in the new calculate measure try to write if condition Measure M.1 if it is below Measure M.2 to green and to red if it is above Measure M.2. (if (m1>m2;1;0))

Step 3 = use the new created measure in the threshold.

Thanks,

Saurabh S.

[Daniel_Kramt · Accepted solution]

Hi Saurabh,

thank you very much!

BR,

Daniel