replace empty value by null

[bboy0009]

Hi guys,

I hope you're doing well !

In my dataflow, on a text column X, I have applied a replace value step : "" to null. This one is necessary because I have added a column Y (with dax) to the same table which will take a value if the value in X is null.

For me , it's null

and it's empty

The problem is : in the dataflow, I do have null in the column X. But in the PBIX, the data that I retrieve from this dataflow are empty but not null. So the column Y doesn't have right value. So I think that the value null from the dataflow is interpreted empty in PBIX because the type is text

I have done a test to transform column X into whole number in the dataflow and I do retrieve null in the column X in the PBIX. So I think it is due to the data type of the column . 

Do you know how could I do to fix this without changing data type of X and without adding another step in the PBIX ?

Thank you in advance !

[bboy0009]

@collinq @djurecic 

Hi guys, 

thank you for the answer !

For more precision, There is a dataflow on which I have already applied the same replace value than yours @collinq . After that, I retrieve data from this dataflow for the PBIX and it's here that I have empty and not null value.That's the problem.

@djurecic At the end, I would like to have null value and no empty value at all   

[collinq]

Hi @bboy0009 

I am not positive I fully understand your post but you can do a "replace value" step (without having to change the data type).  In the replace values, you don't do anything in the first box (do not hit space or anything) and in the second box put in the value you want like this:

Is that what you are looking for?

[djurecic]

Hi @bboy0009 ,

 What is the end result you are looking for- are you trying to show Null and "" as separate vales in your slicer?