fail to show the cell values in visuals probably due to "#(cr)#(If)" in the cell value??

[Anonymous]

Hi experts. I am learning poer bi by myself and i find some interesting problems.

in my query, in the column [Category], there are two sets of values "Performances variable cost (Euro / 100 kg raw milk)" and "Performances full cost (Euro / 100 kg raw milk)". they extend the format in excel sheet, shown in query with feed line like this:

so to check their format, i right click the cell and choose "Replace Values", so it shows : 

we can find that with "cull cost" , there is a "#(cr)#(If)" in it, while with "variable cost" , there is "#(If)". 

Now the problem is, the "full cost" has the same cell value in the fact table and dimCategory table, which is "#(cr)#(If)" inbetween". and the "variable cost" has the same cell value in the fact table and dimCategory table, which is "#(If)". and then i build the relationships between the two tables based on primary key [Category]. but in the matrix visual, it only shows "variable cost", but no "full cost":

Can anyone one help me solve this problem? I am very curious. thanks in advance!!

[BA_Pete · Accepted solution]

Hi @Anonymous ,

For the sake of simplicity, I would probably just do two replace operations on this column in both your fact and dimension tables to clear out all the cr/lf items

First, replace #(lf) with null, then replace #(cr) with null.

Pete