Forum Discussion

FabiNeed's avatar
FabiNeed
Helper I
4 years ago

PowerBI Creating a matrix with text values

I am facing a difficult challenge this time. I got two table from which I want to construct a matrix. Table 1 (called "Entity") contains a parent-child hierachy and looks like this:     Tab...
Need Help
Show and Tell
Tips and Tricks
FabiNeed's avatar
FabiNeed
Helper I
4 years ago

Hi Anonymous 

thanks for your solution. The only thing which is missing is the hirachy which allows to expand or extent items. The expected output should look like this:

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

FabiNeed  Please upload both source file too if possible