query editing - help

[Anonymous]

Hello

i am pulling  data from sql table, one column has "no data " I want this one row to show "Not Available" in power bi visual. is it Possible?

I prefer not to alter backend database and fix this from power bi end if possible.  

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Table:

You may create a custom column with the following codes.

= Table.AddColumn(#"Changed Type", "Custom", each if [Value]=null then "Not Available" else null)

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Nathaniel_C]

@Anonymous hello,

In Power Query, create a conditional column that replaces your no data indicator with "Not Available". Then Delete the original column, and rename the new column to whatever the deleted column was named. (If column = "no data" then "Not Available")

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel