Make Data more Annonymous by parameter or filters

Question

Hi all,&nbsp;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:&nbsp;Original column CustomerName&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;New ColumnAn&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Customer1Thomas&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Customer2Bob&nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BobFrank&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Customer4...&nbsp;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.&nbsp;Anyone that can help?

v-yuta-msft · Accepted Answer

jvangrunderbeec&nbsp;,
&nbsp;
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.

Forum Discussion

Make Data more Annonymous by parameter or filters

1 Reply

Related content

Parameter in summarize

Using parameters to filter to desired number of rows

Filter Field Parameter by Field Parameter Values without Calculated Groups

notebook parameter

Field Parameters - Individual Filters