Forum Discussion
Matrix Visual - Conditional Formatting Removed when Hierarchy Expanded
OK! Here's the cause of the problem: I had the "Appy to" option set to "Values only". The solution is to set it to "Values and totals".
Right click on measure -> Conditional Formatting -> Background
Here's my guess at the reason behind this. With all items in the hierarchy collapsed each row shows values. When you expand even one hierarchy row all rows (except the newly visible lower level) are now TOTALS. The lower level that you just exposed shows values.
Hope this helps someone.
OK! Here's the cause of the problem: I had the "Appy to" option set to "Values only". The solution is to set it to "Values and totals".
Right click on measure -> Conditional Formatting -> Background
Here's my guess at the reason behind this. With all items in the hierarchy collapsed each row shows values. When you expand even one hierarchy row all rows (except the newly visible lower level) are now TOTALS. The lower level that you just exposed shows values.
Hope this helps someone.