Hierarchy for a column Users?

[gpiero]

I am looking for an advice to the following issue working in a report like the one below.

My table contain a column Users (type text). Those users belong to two main groups and perform many movement in the ERP.

So in the Visual level filter I would like to insert two groups instead of select each time all users  =< "98999" and => "99000" selecting one by one.

How can I create two groups and put one of them in the visual level filter?

Thanks

[dkay84_PowerBI]

Do you have a User dimension table that has a field for group?

Do you have a way of defining who belongs to which group programmatically?

[gpiero]

Ok right, I think the second solution could be easier,

I could add a calculated column where discriminate which row belong to a group and which to other one.

Have I understood well you suggestion?

[dkay84_PowerBI · Accepted solution]

Yes. Once you have a row level value for group, you can create your hierarchy easily within in the "axis" of the visual. "Group"-->"User"

[gpiero]

Many Thanks