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

      • tobiasmcbride's avatar
        tobiasmcbride
        Helper III
        6 years ago

        OK sure thing,

         

        So the measure I have for variance is as follows:

         

        Forecasted Variance = (Calculate(COUNTROWS(Headcount), Headcount[Current Status] = "Established") + (Calculate(COUNTROWS(Headcount), Headcount[Current Status] = "New Starter")) - SUM(HCBudget[HC Value])

         

        This then generates the difference in absolute terms between the total of Established and New Starter employees minus the value in the budget column.

         

        I then have 2 slicers for the budget year and type (e.g. 2019 provisional) and the specific dates we are looking at.