Forum Discussion

Karthik12's avatar
Karthik12
Icon for Post Patron rankPost Patron
3 years ago

Table Visualization from 2 different tables

Hello Folks, GM.  I am developing a production data display whereas data comes from 2 different tables. I would like consolidate in one matrix/table visualization as below   Expected format (Fil...
Need Help
Show and Tell
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

Hi,

I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.

One of ways to solve this is to create a Type dimension table like below.

I hope the below can provide some ideas on how to create a solution for your datamodel.