Forum Discussion

1up's avatar
1up
Resolver 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 values, in my examples countries, which with tick boxes checked would change the values in the underlying table to preselected values ?

 

The need is stemming from anonymize the data set. So the data for different countries is anonymized. So instead of the reports stating i.e. 'Australia', 'USA' etc, the labels could be 'Country 1', 'Country 2' etcetera.

 

Thankful for inputs.

 

//Daniel

Need Help
Tutorial Requests

3 Replies

    • 1up's avatar
      1up
      Resolver 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