CONDITIONAL TRAFFIC LIGHT

[Syndicate_Admin]

I have 3 indicators: ind1, ind2, ind3 Each one has a numerator and a denominator with which you have a "Result" of each indicator. In addition, each indicator has a specific "expected achievement". And a "threshold value" but in some cases counted as 0 or does not apply This result varies in whether it is good or not according to the threshold value and the expected achievement, as follows ind1: if the result is greater than or equal to the expected achievement is green; if it is less than the threshold value it is red; and if it is equal to the threshold but less than the expected achievement, it is yellow. IND2: Its threshold value is 0, that is, either you reach the expected achievement or not. so if the result is equal to or greater than the expected achievement it is green, if it is less than the expected achievement it is red. There are no yellow ind3 values: there is no data yet, so the traffic light should mark gray indicating that there is no data. How do I do it so that every time the dashboard of the indicator changes, the traffic light also changes?

[v-pagayam-msft]

Hi @Syndicate_Admin ,
I wanted to check and see if you had a chance to review our previous message or Please let me know if everything is sorted or if you need any further assistance.
if it helps,consider accepting it as solution.
Thank you.

[v-pagayam-msft]

Hi @Syndicate_Admin ,

Could you please confirm if the issue has been resolved on your end? If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.
Thank you for your understanding and assistance.

[v-pagayam-msft]

Hi @Syndicate_Admin ,
I wanted to follow up on our previous suggestions regarding the issue you are facing. We would like to hear back from you to ensure we can assist you further. If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. 
Thank you.

[v-pagayam-msft]

Hi @Syndicate_Admin ,
Thank you @danextian  and @djurecicK2 for the prompt response!
Upon my understanding,I tried to recreate in on ly local.Please refer the below steps:

1.Create a measure for Result using below:

Result Measure = 
DIVIDE(SUM('Indicators'[Numerator]), SUM('Indicators'[Denominator]))

2.Create a measure for KPI Color using below:

KPI Color = 
VAR _Indicator = SELECTEDVALUE('Indicators'[Indicator])
VAR _Result = [Result Measure]
VAR _Expected = SELECTEDVALUE('Indicators'[Expected_Achievement])
VAR _Threshold = SELECTEDVALUE('Indicators'[Threshold])

RETURN
SWITCH(
TRUE(),

_Indicator = "IND1" &&
_Result >= _Expected, "Green",

_Indicator = "IND1" &&
_Result < _Threshold, "Red",

_Indicator = "IND1" &&
_Result = _Threshold && _Result < _Expected, "Yellow",

_Indicator = "IND2" &&
_Result >= _Expected, "Green",

_Indicator = "IND2" &&
_Result < _Expected, "Red",

_Indicator = "IND3", "Gray",

BLANK()
)

3.Create a measure for light colours using below:

Traffic Light Icon = 
SWITCH(
[KPI Color],
"Green", "🟢",
"Yellow", "🟡",
"Red", "🔴",
"Gray", "⚪"
)

 Please refer the screenshot and the file for your reference:

If this solution meets your requirement,consider accepting it as solution.

Thank you for being a part of Microsoft Fabric Community Forum!

Regards,
Pallavi.

[danextian]

Sounds like a good use case for conditional formatting with icons - Apply conditional formatting in tables and matrixes

[djurecicK2 · Accepted solution]

Hi @Syndicate_Admin ,

 Take a look at this article which explains conditional formatting with icons:

https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/