Forum Discussion

pjose's avatar
pjose
Helper I
5 years ago

Connect column header to another table column data

Hi,   I am new to Power BI and I have an issue connecting my tables. I have my data tables in a structure like below.   Table   A                                                                  ...
Need Help
v-janeyg-msft's avatar
v-janeyg-msft
Community Support
5 years ago

Hi, pjose 

 

It’s my pleasure to answer for you.

There is not much data in the dimension table, you can try to subdivide the dimension table, and then create corresponding relationships with the data table.

Like this:

Here is my sample .pbix file. Hope this helps.

If it doesn’t solve your problem, please feel free to ask me.

 

Best Regards

Janey Guo

 

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

 
  • pjose's avatar
    pjose
    Helper I
    5 years ago

    Hi, v-janeyg-msft and amitchandak 

     

    Thank you very much for the answers.

    Those are differet options that I could possibly do.

     

    The example I provided was a really basic one, I am basically working on survey responses with around 10 demographic questions and the rating scale questions (around 40 - 50) for each survey and these questions and answer options will be different for different surveys.

     

    The example I showed is the way we are storing data in different tables (one database per survey) and I am looking into generalizing the approach of connecting the tables and then generating meaningful charts/tables out of them.

     

    This is a sample .pbi file which can give an idea of what I am talking about - Sample .pbi file 

     

    Please have a look and let me know if you have any other ideas around the same.

     

    Thank you again!