Forum Discussion
Solved
Replacing Blanks with NA in Matrix Visual
Hello Community, I have a matrix visual with blanks in the values. I don't have blanks in my data but they are getting generated because of matrix visual properties. I want to replace the blanks ...
Never Mind, I got the answer for my question by myself.
The solution i have is to divide my fact table to multiple tables and load it into matrix visual.
Create a new measure -
sts =IF(SELECTEDVALUE(subj[Subject])="French" && SELECTEDVALUE(cnt[Country])="US","NA",SELECTEDVALUE(Sheet1[Status]))load the above measure into values section of matrix visual.If someone have better solution, please feel free to drop it.
Never Mind, I got the answer for my question by myself.
The solution i have is to divide my fact table to multiple tables and load it into matrix visual.
Create a new measure -
sts =
IF(SELECTEDVALUE(subj[Subject])="French" && SELECTEDVALUE(cnt[Country])="US","NA",SELECTEDVALUE(Sheet1[Status]))
load the above measure into values section of matrix visual.
If someone have better solution, please feel free to drop it.