Forum Discussion
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...
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.
Jihwan_Kim I working for me. Thank you !🙂
But only thing, If Gap color is not working. If Gap > 0, it should be green, <0, it should RED.
Can you please check?
Also, my table has lot of other names like below
Is it possible to show only rows which has either plan or prod qty numbers?
Hi,
Thank you for your feedback.
Please share your sample pbix file's link (onedrive or others), and then I can try to look into it to come up with a more accurate solution.
Thanks.