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

[1up]

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

[v-kelly-msft]

Hi @1up ,

Based on my research, it is not supported yet currently. You can come up with a new idea and add your comments there to make this feature coming sooner.

https://ideas.powerbi.com/forums/265200-power-bi-ideas

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

Refer, if this can help : https://www.biinsight.com/power-bi-desktop-query-parameters-part2-dynamic-data-masking-and-query-par...

[1up]

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