Add # to Blank Value

[ADSL]

Hi BI Community Team,

I hope you're doing well.

I have 02 tables -- sales team master & sales order that I am handling a few sales team and not all but sales order table have for all.

So then I am doing the sales dashbaord, it is blank as the screenshot below.

Any suggestion to add "#" or "Unknown" in the blank?

Thanks and Regards,

[IoannisPhilip]

Hi @ADSL ,

You can go to your table editor and click on "Replace Values", there leave the first replace value empty and then input to the "Replace With" sign "#" or whatever you like.

That should do the trick. I am not sure what the structure of your source tables is, but maybe you need to replace the values there. Let me know if you face any issues.

Best regards,
Ioannis

[ADSL]

Hi @IoannisPhilip,

Thank you for your feedback.

In Sales Order table, it has a lot of sales rep code and we manage some with master sales rep table have sales rep code, team,..etc.

To Replace Value, we cannot do because it doesn't have blank value.

Any suggestion?