Conditional Formatting One Value Different Icons

[Vitalijus]

Hi,
Created a simple Conditional Formatting rule, but sometimes value 1 shows Yellow which is incorrect, according to the rule value 1 shuld be Green always, where could be the problem? I posted like 14 decimal places but is still 1.

Thanks

[v-lili6-msft]

hi  @Vitalijus 

If you change the data type from decimal number to Fixed decimal number and try it again.

and if you still have the problem, please share your sample pbix file for us have a test.

Regards,

Lin

[Anonymous]

Agreed with Pragati11, check the data types.  Is there DAX doing the calculation?  If not, try coding the DAX one of three ways:

DivideColumn = Numbers[Actual]/Numbers[Forecast]

DivideMeasure = SUM(Numbers[Actual])/SUM(Numbers[Forecast])

DivideMeasureDiv = DIVIDE(SUM(Numbers[Actual]),SUM(Numbers[Forecast]))

Tested all three and the behavior was the same (June 2020 release).

[Pragati11]

Hi @Vitalijus ,

Are values in "AQ+Orders / Forecast" decimal type?

They look like they are not. I see a comma in them rather than a dot which is for decimal numbers.

Check datatype of your column.

Thanks,

Pragati

[amitchandak]

@Vitalijus ,  Try this, if it can work. Create a rounded 2 or 3 decimal place number and have conditional formatting on that.

Also, log and check issue at :

https://community.powerbi.com/t5/Issues/idb-p/Issues