Make Data more Annonymous by parameter or filters

[jvangrunderbeec]

Hi all,

I have a dataset with a customertable. It contains something like 60 names. I need to make something (slicer, parameter, ...) that when clicked on a customer-name, changes all other names into 1,2,3 or something like that. So for example if you click on Customername: "Bob" the list should be:

Original column CustomerName               |          New Column
An                                                              |          Customer1

Thomas                                                      |          Customer2

Bob                                                            |          Bob

Frank                                                          |          Customer4

...

I Already tried query parameters, but as i understand this only changes the dataset and is not dynamic. As the users of my report only will acces with the PBI service this is not an option. I tried What-if parameter, but this doesn't work in a calculated column. I've got the right dax statement with the what-if parameter in a measure to achieve what i need, but now i can't display the customer-names on an axis.

Anyone that can help?

[v-yuta-msft · Accepted solution]

@jvangrunderbeec ,

Generally, you can create an index column and then create a measure like pattern below and check if it can meet your requirement:

New Column =
IF (
    MAX ( Table1[Original column CustomerName] )
        = SELECTEDVALUE ( Table1[Original column CustomerName] ),
    SELECTEDVALUE ( Table1[Original column CustomerName] ),
    CONCATENATE ( "Customer", MAX ( Table1[Index] ) )
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.