cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper IV

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

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

1 ACCEPTED SOLUTION
Super User

Hi @NickzNickz ,

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 🙂

 Did I answer your question❓➡️ Please, mark my post as a solution ✔️

 Also happily accepting Kudos 🙂

 Feel free to connect with me on LinkedIn!

 #proudtobeasuperuser

2 REPLIES 2
Super User

Hi @NickzNickz ,

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 🙂

 Did I answer your question❓➡️ Please, mark my post as a solution ✔️

 Also happily accepting Kudos 🙂

 Feel free to connect with me on LinkedIn!

 #proudtobeasuperuser

Helper IV

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

Regards,

NickzNickz

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors