Forum Discussion

tobiasmcbride's avatar
tobiasmcbride
Helper III
6 years ago

Conditional Formatting Quirks

Hi,   I have data for forecast and budget. The former is a measure which calculates forecast headcount based not only on whether they are established already but also adds in if they are due to joi...
Need Help
tobiasmcbride's avatar
tobiasmcbride
Helper III
6 years ago

Hi,

 

I don't see the 'number' or 'percentage' icons for this measure. This is a measure I am using and I am using a table not a matrix. 

MFelix's avatar
MFelix
Super User
6 years ago

Hi tobiasmcbride ,

 

Is your measure in number format? Can you share your measure formula please?

  • tobiasmcbride's avatar
    tobiasmcbride
    Helper III
    6 years ago

    Hi,

     

    I can't share the measure formula just now but essentially it calculates the rows which have certain text values, takes away the sum of the budget. That is then filtered (by slicers) by date and which estimate (final or provisional) we have.

     

    When I head to the data conditional formatting tab for that measure (forecast variance) I can enter values but no 'number or percentage' type appears. 

     

    Again this is for a visual table that I am creating and want to show for. 

    • MFelix's avatar
      MFelix
      Super User
      6 years ago

      Then it's because your measure is returning a text value and not a number value.

       

      check the format of the measure to see if it's as a number or text please.

      • tobiasmcbride's avatar
        tobiasmcbride
        Helper III
        6 years ago

        Hi 

         

        I have checked and the measure is formatted as a number and still not working.