How to get Parent name from hierarchy
I have SQL table Groups with next columns:
- Id
- Name
- ParentId
Also I have table Articles where every Articles belongs to only one group. Some of groups are Parents to others groups. With this two tables I created Dimension Articles where I have hierarchy like this:
- ArticleId
- GroupId
- ParentGroupId
This works well (it think there is way to even this optimize, but this is not the issue).
My figure in PowerBI look like this then
But I don't know how to manage to put Groups Names to show in Figure. When I put groups name in figure then is only shown my child groups names not parents.
How can I show names of groups even for child and parents also? Model is Multidimensional so hierarchy and dimension is in cube.