topic If result return "Not Started", then text is red color in DAX Commands and Tips

If result return "Not Started", then text is red color

NickzNickz — Tue, 18 Apr 2023 01:44:37 GMT

Hi ...

Below is my measure :

Weighted Achievement (%) =

VAR Score = SUM('kpidb kpi_submissions'[score])

VAR Weightage = SUM('kpidb kpis'[weightage])

VAR Stage = 3

VAR Result = Score / Stage * Weightage

RETURN

IF(ISBLANK(Result), "Not Started", Result)

How can we return if the result equal to "Not Started" then the text should also in red color ....

Thank you

Regards,

NickzNickz

tackytechtom — Tue, 18 Apr 2023 03:46:19 GMT

You could create an additional measure which looks like this:

ColourCodeMeasure = If ( [Measure] = "hello", "red", BLANK() )

Here the result for my mockup data:

Your measure would be something like this. Note you could even use HEX number instead of "red":

ColourCodeMeasure = If ( [Weighted Achievement (%)] = "Not Started", "red", BLANK() )

Then click on the arrow facing down in the visualization pane > Conditional Formatting > Font Color

Choose the following settings:

Let me know if this helps 🙂

NickzNickz — Wed, 19 Apr 2023 02:47:55 GMT

Really appreciate it... The result is as expected.... Thanks a lot ...

Regards,

NickzNickz