Forum Discussion

benjamincoady's avatar
benjamincoady
Helper I
6 years ago
Solved

Conditional Formatting on Tables

Hi,    I'm not sure if a recent update has changed this but it's become more difficult to create conditional formatting on tables based on a minus value.    I'm trying to make the background of t...
Need Help
  • benjamincoady's avatar
    benjamincoady
    6 years ago

    Hey mwimberger , 

     

    I think I solved it, basically it need a text field to reference against. It was weird but once I dropped in the Project field (Text) into the table, all of the conditional formatting came to life. Strange and never experienced it before! 

     

    Thanks for your input though, really appreciate it. 

     

    Ben

benjamincoady's avatar
benjamincoady
Helper I
6 years ago

Hi both mwimberger v-juanli-msft , 

 

I've just done another update and mine is still completely different from both of yours, I don't even have the number field that v-juanli-msft has. 

 

 

Do you think it's worth doing a full uninstall and reinstall? Can't understand why it would be so different. 

 

Thanks for your continued help! 

mwimberger's avatar
mwimberger
Resolver II
6 years ago
Hi

So I doubt a reinstall will do anything. I would check the field you are trying to get the formatting for isn’t set to mixed text and numbers or maybe text . It may trip it up in this case.
You can set this in the modelling tab or in the Power Query step.

Cheers

Manfred
  • benjamincoady's avatar
    benjamincoady
    Helper I
    6 years ago

    Hi mwimberger ,

     

    Just checked, the values are set to (Whole Number) and (Currency).

     

    I set up a new file and entered a quick test table. I then set the following rules, this should turn column 1 the correct colour but nothing happens.

     

     

    • mwimberger's avatar
      mwimberger
      Resolver II
      6 years ago

      Hi benjamincoady 

       

      Weird. I have created a pbix with various formats as well as a video on the deletion of the percent ( to illustrate 0 percent is same as minimum number). The weird thing is you are not seeing those extra fields.

      Check the PBIX in the link (Conditional Formatting PBIX and Video - OneDrive and compare to the video and see if you can see what I see. If you don't - maybe consider an uninstall and reinstall as a last resort.  Not sure if you download from the Microsoft Store or direct download though I doubt this makes a difference - but do check if your version in File / Options and Settings/ Diagnostics is 2.74.5619.862  ( which should be the latest as at 2/11/2019) Use this link Advanced Download Link  

       

      Hope you crack this one soon mate,

       

      Cheers

       

      Manfred

      • benjamincoady's avatar
        benjamincoady
        Helper I
        6 years ago

        Hey mwimberger , 

         

        I think I solved it, basically it need a text field to reference against. It was weird but once I dropped in the Project field (Text) into the table, all of the conditional formatting came to life. Strange and never experienced it before! 

         

        Thanks for your input though, really appreciate it. 

         

        Ben