Forum Discussion

tobiasmcbride's avatar
tobiasmcbride
Icon for Helper III rankHelper 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
Icon for Helper III rankHelper 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
Icon for Super User rankSuper 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.