Forum Discussion

EaglesTony's avatar
EaglesTony
Post Prodigy
3 years ago
Solved

Conditional Coloring not working

Hi,     I had one report working on Conditional Coloring, but this new one I can't seem to get it to do conditional coloring for some reason.     I have a column PCT Complete that in the data is ...
Show and Tell
  • EaglesTony's avatar
    EaglesTony
    3 years ago

    I think I found a solution to it.

     

    The field PercentComplete is of Data type "Decimal Number" and Format "Percentage" with 0 decimal places.

     

    A new field needs to be created to convert this into a whole number (i.e. newfield = PercentComplete * 100) and this new field needs to be of Data type "Whole number" and Format "General" asd Auto as decimal places.

     

    In the conditional formatting, I had to use this new field that is a whole number and not the percentage field.

     

EaglesTony's avatar
EaglesTony
Post Prodigy
3 years ago

Thanks, but that did not work and even tried to move them around with no luck.

DOLEARY85's avatar
DOLEARY85
Resident Rockstar
3 years ago

Are you able to share the PBIX file?

  • EaglesTony's avatar
    EaglesTony
    Post Prodigy
    3 years ago

    Did you create a simple table and try to do the conditional formatting on it ?

  • DOLEARY85's avatar
    DOLEARY85
    Resident Rockstar
    3 years ago

    Yeah, it was very basic with just a unique row and a percentage.

  • EaglesTony's avatar
    EaglesTony
    Post Prodigy
    3 years ago

    Is it working correctly ?

     

    If so, can you share what your field definition is and your conditional rule setup on this field ?