Forum Discussion

Abbi's avatar
Abbi
Icon for Helper I rankHelper I
4 years ago
Solved

How to create a custom table or Matrix table

Hi All, Looking forward for your help. I have 2 tables, Table1 and Table 2. Table1 - ID Depedency Owner 1234 Client Maruti 1234 Testing Maruti 1234 Engg Maruti 8125 Suppor...
  • Icey's avatar
    Icey
    4 years ago

    Hi Abbi ,

     

    Please check this:

     

    Detail steps:

    1. Create two tables.

    ID = 
DISTINCT ( UNION ( DISTINCT ( Table1[ID] ), DISTINCT ( Table2[ID] ) ) )

    Depedency = 
DISTINCT (
    UNION ( DISTINCT ( Table1[Depedency] ), DISTINCT ( Table2[Depedency] ) )
)

     

    2. Create relationships.

     

    3. Create a Matrix.

     

     

    For more details, please check the attached .pbix file.

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
4 years ago

Hi,

I recommend approaching this a bit differently. With these steps you can visualize the information you want quite well.
You can create a dimension table like this one:

and then use it to create relationships:

 

By doign this you can create the visual like this:
Use the dimension table for slicer and then just create two table visuals.

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/