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
Anonymous's avatar
Anonymous
Not applicable
4 years ago

HI FabiNeed 

Could you please add the exact expected output? I am getting below output is correct?

 

  • 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