Forum Discussion
Data not available
Hi, Please see the image below. I have some data for december. But january data is not available yet. So im hardocding it in the return statement saying if(isblank(result),0, result) Is the...
klehar , Create a measure to check if the data is available.
JanuaryData =
IF(
ISBLANK(SUM('YourTable'[JanuaryColumn])),
BLANK(),
SUM('YourTable'[JanuaryColumn])
)
Then, create another measure to handle the display logic:
DisplayJanuaryData =
IF(
ISBLANK([JanuaryData]),
"Not Available",
FORMAT([JanuaryData], "0")
)
Go to the matrix visual and select the JanuaryData measure.
Apply conditional formatting based on the value of JanuaryData.
Set the formatting rule to display "Not Available" when the value is blank.