Forum Discussion
gpiero
Skilled Sharer
Skilled SharerHierarchy for a column Users?
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
- 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"
4 Replies
- dkay84_PowerBI
Microsoft Employee
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_PowerBIYes. Once you have a row level value for group, you can create your hierarchy easily within in the "axis" of the visual. "Group"-->"User"
