Masked Data getting added up

[Anonymous]

Hi Team,

i ran into a situation where i had to mask the account Number and display the masked account number against the balance available for them. 

How the data is actually before masking: 

Account Number	Account ID	Balance
111234	1	10
121235	2	20
131234	3	30

Output:

 

Account Number	Account ID	Balance
XX1234	1	10
XX1235	2	20
XX1234	3	30

After Masking the acoount Number for Account ID 1 and 3 looks same and gets adds up and the visual is now depicting wrong data

 How to overcome this situation. 

Thanks in Advance

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can try my calculated column to mask the data. It distinguishes Account Number by adding a space after it.

Masked Account Number =
"XX" & RIGHT ( [Account Number], 4 )
    & REPT ( " ", RANKX ( 'Table', 'Table'[Account Number],, ASC, DENSE ) )

Then Account ID 1 and Account ID 3 will not be merged.

You can check more details from here.

Best Regards,

Stephen Tao

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

[Anonymous]

Hi @Anonymous 

we are receiving masked data so we need not add XX in the start. 

I just changed the DAX a little and i was able to get the solution 🙂

Calculated_Column :=( [Account_NO] & REPT ( " ", RANKX ( 'TableName', 'TableName'[Account_ID],, ASC, DENSE )))

Hope this is correct !

Thanks for guiding 🙂

[dedelman_clng]

Hi @Anonymous  - this is by no means "pretty" or "elegant", but here's one possible workaround.

Change the bar chart to a matrix, and add Acct ID (or Acct Number - something unique) as a second row header.

Go to Column Headers, and turn off Word Wrap, then shrink Acct ID column down to nothing.

Under Style, choose "None"

Under Row Headers, turn off "Stepped Layout" and "+/- icons"

Under Field Formatting, set "Alignment" to "Left"

Under Conditional Formatting, add "Data Bars" for balance. You may use the default settings.

Here is the output. Not really a bar chart any more, but it might do the trick

Hope this helps

David

[amitchandak]

@Anonymous , Not sure this will work you. But there is a masking solution discussed here

https://radacad.com/show-the-information-but-not-the-details-power-bi-data-masking