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
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. 

      • MFelix's avatar
        MFelix
        Super User
        6 years ago

        Hic tobiasmcbride ,

         

        Witouth any example is difficult to give you a better explanation, can you share some mockupdata and the measure you are using to calculate the Variance?

         

        If this is sensitive information you canshare it trough private message or with mockup values, as I refered to you I have made some test and was abble to make the condittional formatting but my model for sure is not equal to yours is just a simple column with forecast and budget columns.