Forum Discussion
EstherBR
Helper III
Helper IIIHighlight blank cells
Hi,
I have the following data models and report:
Matrix Product: Table Product
Matrix Spain: Table Country
I have created the following format measure:
Format = SWITCH(
TRUE(),
ISBLANK([Parameter Value]), "#FFFFFF",//Black
[Parameter Value] < [Country Sales SUM], "#EFB5B9", //Red
[Parameter Value] = 0, "#FFFFFF",//Black
"#FFFFFF"//Black
)
I have added the measure to the cell elements format of both matrixs.
I would like that when the sum of sales is higher than the value entered by the user in the parameter, the Spain matrix sum of sales is highlighted in red and the same month column of the Product matrix is also highlighted in red. The issue is when some values of that column are blank. ¿Is there any way to highlight the whole month column?
Thank you so much!
pls try
4 Replies
- amitchandak
Super User
EstherBR , Blank can be highlighted in Gradient and Rule Based(I think added sometime back) conditional formatting. It is not supported in field value.
EstherBRThanks amitchandak, but this has not worked since in the Product matrix, the only month that has to be highlighted has to be the same one as in the Spain matrix.
- Ahmedx
pls try
