Forum Discussion

1up's avatar
1up
Icon for Resolver I rankResolver I
6 years ago

Replace data labels in graphs? Or replace column values triggered by a table list?

Hi, is it possible to replace data labels in graphs? As I read it may not be possible today.   Alternatively, would it be possible to create a Table in the Report-view, with a single column of valu...
Need Help
Tutorial Requests
1up's avatar
1up
Icon for Resolver I rankResolver I
6 years ago

I tried the code on the suggested site in the Query Editor, however it seems the code perhaps should be used elsewhere as I don't get it to work. I get '='-sign expected on the first row using:

 

   ALTER TABLE Table_Name ALTER COLUMN Column_Name1 ADD MASKED WITH (FUNCTION = ‘Mask_Function’);

 

The base data is coming from an Excel-file. Not sure if the source needs to be an SQL-server for it to function.

 

Ideas anyone?

 

From the home page:

Alter an existing table and enable DDM on desired columns

As you guessed you have to use “ALTER TABLE” then “ALTER COLUMN”. Your T-SQL should look like:

ALTER TABLE Table_Name ALTER COLUMN Column_Name1 ADD MASKED WITH (FUNCTION = ‘Mask_Function’);

GO

ALTER TABLE Table_Name

ALTER COLUMN Column_Name2 ADD MASKED WITH (FUNCTION = ‘Mask_Function’);

GO