How to keep all products anonymised while revealing just one product id?

[Anonymous]

Hi All,

I have list of product ID say A,B,C,D. They have been anonymised to 1,2,3,4 respectively.

Now if I want a table visual where I wish to see product C's performance as product C while keeping other products as 1,2 and 4. is that possible?

[Anonymous · Accepted solution]

@Anonymous 

Columns are always static, it is not possible to have dynamic columns, and using parameter cannot achieve what you are expecting. For your requirement, you may only create a measure and a slicer. Check the my example below.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks a ton! This is what I needed, Cheers 🙂

[PhilC]

Hi, you might want to investigate using a parameter to select the product to display, as I think that cannot use text.

The code below uses a Product table with teh Name in a slicer to be the dynamic selection, then uses that value to either display the Original product of the Anonymised Name.

Product Selection = if(HASONEVALUE('Product List'[Product Name]),SELECTEDVALUE('Product List'[Product Name]),"Product Z")

Dynamic Product Name =
IF(MAX('Table'[Orginal Product Name])=[Product Selection],MAX('Table'[Orginal Product Name]),MAX('Table'[Anon Product Name]))

Cheers

[Anonymous]

Hi Phil,

Thanks for the above, just to confirm, shall I create 2 parameters, one as Product selection and another as Dynamic Product Name? Because I created Product selection as Parameter abd entire visualtion is just filtering with respect to product selected so I can see just Product C in my visualisation.

Regards,

Apurva

[PhilC]

The suggestions I provided were measures, not parameters.  As mentioned previously, I do not think a parameter will work, but read up on them to determine that.  You might need to use a separate table of all Product Name values and use a slicer to select the value to display.  (Note - it needs to be a separate table so the filtering you are experiencing does not happen).

If you need more assistance please post a Power BI workbook with your model as this is the easiest way to assist you, and putting it together will really help your learning.

Cheers

[PhilC]

How will you select the product you want to display?  Slicer?  Parameter?

Add a calculated column (Dynamic Product Name) that tests that value to see if it matches the value in the Original Product Name, when TRUE, use Original Product Name, when FALSE use Anon Product Name.  Then display Dynamic Product Name field.

[Anonymous]

Hi Phil,

I want to display this is parameter.. can you share how to create dynamic calculated column to match the product name?

Can this be done that we create a measure where if that measure contains Product ID as 3 then name it as Product C? Something like this? Not sure if that's appropriate since i'm new to Power BI

[Gabriel_Walkman]

Many simple ways to achieve this. Just duplicate the anon name column and rename the product in question as it should be.

Do you need to be able to dynamically change what product name will be revealed?

[Anonymous]

Yes, I need to dynamicaly change what product name shall be revealed, like see the example below

Product ID    Total Sales

1                     2500

2                     3000

Product C      4560

4                     2750

Is this possible in Power BI?