How to get Parent name from hierarchy

Luka Otočan 21 Reputation points

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:

  1. ArticleId
  2. GroupId
  3. 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.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,632 questions
{count} votes