SUMMARY:
When using custom banding in reports, sometimes is necessary to not apply it over the Metric Columns. This feature is not able in the MicroStrategy 9.x
SYMPTOM:
Currently in MicroStrategy 9.x, Custom Banding is always applied on both Attributes and Metrics, as follow:
![image001](https://community.microstrategy.com/legacyfs/online/UploadContent/45k/TN40376_TN40376_0.png)
WORKAROUND:
Follow the steps below to apply Custom Banding only on Attributes by using thresholds for specifing a unique color to all metric values:
1 – Click on the Threshold icon.
2 – Select the desired Metric.
3 – Select Is Not Null as operator.
![image003](https://community.microstrategy.com/legacyfs/online/UploadContent/45k/TN40376_TN40376_1.png)
4 – Click on the cell to enable the Format Cells editor.
5 – Go to Background tab, set the Background style as Solid and choose one color.
![image005](https://community.microstrategy.com/legacyfs/online/UploadContent/45k/TN40376_TN40376_2.gif)
6 – Repeat the steps 2 to 5 in order to create one more Threshold qualification selecting the operator Is Null.
7 – Change the operator AND to OR according to image below.
![fiwamoto-921 - Remote Desktop Connection_2012-06-27_10-40-55](https://community.microstrategy.com/legacyfs/online/UploadContent/45k/TN40376_TN40376_5.png)
8 – It will apply the same color to all metric values:
![image006](https://community.microstrategy.com/legacyfs/online/UploadContent/45k/TN40376_TN40376_3.png)
TN40376: How to apply Custom Banding only on Attributes in MicroStrategy 9.x