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 with "NA" based on a condition given below.
Matrix Visual -
Condition - If the country = US then french column should be NA,
My Dataset -
My rows and columns -
Any help would be appreciated.
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.
1 Reply
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.