removal of label blank space

[#1]

Hi,

I have a pie chart that shows region , city values

[#2]

bump

[fvelascog72]

Try this:

In expression use: if (isnull(Region),'',Region)

[#4]

Hi,

Load in script level like below it will replace - with space & also hide '-' mark in pie-chart

Germ:

LOAD ID,

     if(isnull(Region),' ',Region) as Region,

     City,

     Zip_Code,

     round(Longitude) as Latitude ,

     round(Latitude) as Longitude

FROM

(ooxml, embedded labels, table is Sheet1);

[#5 · Accepted solution]

Hi,

If you create a custom expression set to use the Text as Popup attribute then this will give you the type of label you are after.

I have modified your sample model to illustrate how this could work.

Hope this helps.

Kind regards,

Rod