Forum Discussion
Conditional Formatting Quirks
Hi tobiasmcbride ,
I have tried and was abble to setup the visualization be sure that you have place the option to number (by default appears percent) and that you are placing the max and minimun on the correct place.
If you are using a matrix be aware that the condittional formatting doesn't work on total values so if you do not have any row values it considers it's a total line and doesn't returns any formatting.
- tobiasmcbride6 years agoHelper III
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.
- MFelix6 years agoSuper User
- tobiasmcbride6 years agoHelper III
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.