To implement this recipe, do the following:
- Create the following column in the R11_Table table:
Anonymous =
VAR __Table =
{
UNICODE(MID('R11_Table'[Name],1,1)),
UNICODE(MID('R11_Table'[Name],2,1)),
UNICODE(MID('R11_Table'[Name],3,1)),
UNICODE(MID('R11_Table'[Name],4,1)),
UNICODE(MID('R11_Table'[Name],5,1)),
UNICODE(MID('R11_Table'[Name],6,1)),
UNICODE(MID('R11_Table'[Name],7,1)),
UNICODE(MID('R11_Table'[Name],8,1)),
UNICODE(MID('R11_Table'[Name],9,1)),
UNICODE(MID('R11_Table'[Name],10,1))
}
RETURN
CONCATENATEX(__Table,[Value])
- On a Report page, create a Table visualization and place the Anonymous and Salary columns into the Values area of the visualization.