Conditional formatting not working properly

[o59393]

Hi all

I am using a conditional formatting with the following rules.

If equal to 1 then green

If >= 0 and less than 0 then red

If greater thaan 1 then red

As pointed above in the blue arrows, some values with 100% are not showing the green, while others are.

How can I make the 100% values show a green value?

The values don't have extra decimals.

Thanks.

[mhossain]

@o59393 

If you apply green criteria as  " greater then equal to 0.99999".

Agree with @FrankAT  those reds must be not equal to100.00% in pbi if probably increase decimal to 9 digit probably.

[o59393]

Hi @mhossain , it turned everything into red with 0.99999.

Thanks!

[mhossain]

@o59393 

0.99999 will go with number (not the percent) :), I am sure you must be doing correctly.

[Anonymous]

Hi @o59393 ,

Logic looks fine, what is checkmix in your data? Better to share the pbix to us if you don't have any Confidential Information.

Best Regards,

Jay

[FrankAT]

Hi @o59393 ,

try the following logic:

• if is 1 => green
• if is <> 1 => red

Regards FrankAT

[o59393]

Hi @FrankAT 

What would be the <> option?

Also, please consider that if it is greater than 1 it should be red. Green is only for =1.

I only have these:

Thanks.

[FrankAT]

Hi @o59393 ,

yes you are right, that's may fault. Here is my solution:

Regards FrankAT

[o59393]

Hi @FrankAT 

I did it as you mentioned:

But still shows in red 😕

And also it added by defaul a 0% and 100% when I reopen the conditional formatting:

Could there be a problem with Power BI?

Thanks.

[FrankAT]

Hi @o59393 ,

I think you must take a look at the values of Chek mix. Round them to a whole number.

Yes, the dialog conditional formatting is a little bit messy, but that's not the problem!

Regards FrankAT

[o59393]

Hi @Anonymous  and @FrankAT 

I attach a pbix, I can't figure out why it's marking red the 100% value:

https://1drv.ms/u/s!ApgeWwGTKtFdhyDsUmWn7PR4vNTY?e=aPbYhY

Just in case, the datasource is a Sharepoint list.

Thanks!

[FrankAT]

Hi @o59393 ,

it's all right with the conditional format. The representation of the percentage with two decimal places shows why the different background color is applied (see figure):

 Regards FrankAT

[o59393]

Hi @FrankAT 

I picked the wrong datasource, my bad !

Here is the one: https://1drv.ms/u/s!ApgeWwGTKtFdhyDsUmWn7PR4vNTY?e=9kjOQF

Please use that one.

Thanks!

[FrankAT]

Hi @o59393 ,

I think the problem is the internal conversion from binary to decimal.

Normally, this error can be fixed by rounding the number. With the numbers in your example, it is not possible for a reason unknown to me.

 Regards FrankAT

[o59393]

Thank you @FrankAT !

Appreciate your support, @Anonymous any idea how to fix what @FrankAT  mentions?

Thanks both.

[o59393]

hi @Anonymous 

any idea how to solve this issue that @FrankAT comments?

Thanks!

[Anonymous]

Hi @o59393 ,

I'm a little comfused about your measure [Check mix], I create a measure as below and get the different result. Can you share the logic about your measure?

Measure 2 = CALCULATE(SUM('Honduras - Balance your lines'[Mix(%)]),SUMMARIZE('Honduras - Balance your lines','Honduras - Balance your lines'[Line],'Honduras - Balance your lines'[Plant],'Honduras - Balance your lines'[SKU]))

 

Best Regards,

Jay