Forum Discussion

Delyan_Kirilov's avatar
Delyan_Kirilov
New Member
2 years ago

Powerbi Relationship

Hi team,


I have a case where I want to create a relationship between two tables. One carries timepoints and the header row is the identifier. Looks like this:

 

The second carries metadata for the same series, where the identifier is now a column.

 

 

My ultimate goal is to be able to create a relationship so that I can apply in the report a filter of let's say 'Freq = Monthly' or 'Country = United States' and that should filter only the applicable Series Names and their timepoints from the first table.


I've been struggling with this for the past hour. Let me know if you have come across the same situation.


Thanks in advance!

 

Need Help
Tips and Tricks

4 Replies

  • Dinesh_Suranga's avatar
    Dinesh_Suranga
    Continued Contributor
    2 years ago

    Hi Delyan_Kirilov ,

     

    Select the first row of the first table and unpivot other columns. Then you can create the relationship.

    If you want you can create unique Series Name table to.

    Thanks
    Dinesh

    • Delyan_Kirilov's avatar
      Delyan_Kirilov
      New Member
      2 years ago

      Hi Dinesh,

       

      Thank you for your quick help. I've tried this in the beginning and the relationship is possible then. The issue is that in this form the timeseries are not very usable in the visualisation panel. The are grouped under one attribute and plotting two economic variables now becomes very hard and not native for PowerBi. 

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Thank Dinesh_Suranga  for your prompt reply.

        Hi Delyan_Kirilov ,

        Can you provide detailed data (without sensitive information) and provide the outputs expected for the economic variables. This will allow us to better understand and solve the problem you are having.

        How to Get Your Question Answered Quickly - Microsoft Fabric Community

        If it does not help, please provide more details with your desired out put and pbix file without privacy information.

         

        Best Regards,

        Ada Wang

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