cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jvangrunderbeec
Frequent Visitor

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 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?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: Make Data more Annonymous by parameter or filters

@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.

View solution in original post

1 REPLY 1
Community Support
Community Support

Re: Make Data more Annonymous by parameter or filters

@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.

View solution in original post

Helpful resources

Announcements
‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors