Forum Discussion

jvangrunderbeec's avatar
jvangrunderbeec
Icon for Helper I rankHelper I
7 years ago
Solved

Make Data more Annonymous by parameter or filters

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...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    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.

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
7 years ago

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.