Conditional Formatting

[EB09]

Hi all, 

I'm trying to create a visual which uses conditional formatting, the problem is that it isn't reacting the way I want it to. This is what I have done:

Yet when I do it there are bars on my visual at 87% for example that are coming out green. 

I am doing it from here:

Am I doing something wrong? Is anybody able to tell me a better way?

Thanks!

[_AAndrade]

Chage percent to number at your conditional formulas.
For example: 0 ; Number ; 0.80 Number.

[EB09]

I tried this, stillthe same problem

[_AAndrade]

Can you share your pbix?

[Gayatri_D05]

Hi @EB09 ,
The formatting looks good.
Can you share your measure salary completion % ?
Maybe the calculated value datatype seems to be causing an issue.

If your requirement is solved, please make THIS ANSWER as SOLUTION and help other users find the solution quickly. Please hit the LIKE button if this comment helps you. 😊 

[EB09]

Hi,

Yeah I'm not sure why it's not working!

Measure:

Salary Completion Percentage =

DIVIDE(

    CALCULATE(

        COUNTROWS('New Data Integrity'),

        'New Data Integrity'[Salary KPI] = "Salary Complete"

    ),

    COUNTROWS('New Data Integrity'),

    0

)