How to replace null's in dimension with a string in Line chart

[SatyaPaleti]

Hi Everyone,

How to replace null values in a line chart dimension with a string 'No Branch Available'. Here is the screenshot for reference

I am having a dimensions like Month, State and Measures count(Suppliers) in a line chart. There is a filter pane 'BRANCH'. in Branch if we select Warehouse 15 data will become null because no data for it. so in Dimension it show '-' we have to replace '-' with 'No Branch'. Can someone help on this

Here is the attached files for sample data and sample qvf 

Thanks,

Satya

[Anil_Babu_Samineni]

Please share a sample QVF to playaround?

[SatyaPaleti]

Hi Anil,

Thanks for your response please fid attached document for sample file and sample qvf

Thanks,

Satya