Forum Discussion

Vitalijus's avatar
Vitalijus
Frequent Visitor
6 years ago

Conditional Formatting One Value Different Icons

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

Need Help

4 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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).
  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    6 years ago

    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