Blank category in Matrix

[admin_xlsior]

Hi guys,

In my matrix I had an empty category. Cause is obviusly because there is no value, but is there a way to put this blank as some text like "Undefined" or anything else ?

Thanks

[v-yingjl · Accepted solution]

Hi @admin_xlsior ,

Just replace blank value in the column with 'Undefined' in power query:

= Table.ReplaceValue(#"Changed Type","","Undefined",Replacer.ReplaceValue,{"Failure code"})

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@admin_xlsior , In case there are two tables. There are missing values on one side. Correct those to get this corrected