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...
Need Help
Tips and Tricks
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.

Delyan_Kirilov's avatar
Delyan_Kirilov
New Member
2 years ago

Hi Ada,

 

Thank you for assisting me. The community portal doesn't allow me to attach an xlsx file, but let me describe the issue below.

 

Here's an example table. It has more than one metadata description (name of the indicator, country, frequency, etc.). 

In the conventional table, we only have one column header (indicator name). The idea is to be able to create a dashboard to allow users to filter with all other metadata fields too. Imagine charts, where you click on a slicers with 'countries' or 'frequencies' and that filters series with only that attribute. Do you know an elegant way to do that?

 

 

 

 

 

Series Name(DC)Exports: fob: Advanced Economies: Italy(DC)Exports: fob: Advanced Economies: Spain(DC)Exports: fob: Advanced Economies: Portugal(DC)Exports: fob: Advanced Economies: Portugal(DC)Exports: fob: Advanced Economies: Ireland(DC)Exports: fob: Advanced Economies: Ireland(DC)Exports: fob: Advanced Economies: Greece
RegionItalySpainPortugalPortugalIrelandIrelandGreece
FrequencyQuarterly, ending "Mar, June, Sep, Dec"Annual, ending "Dec" of each yearQuarterly, ending "Mar, June, Sep, Dec"MonthlyMonthlyAnnual, ending "Dec" of each yearMonthly
UnitUSD mnUSD mnUSD mnUSD mnUSD mnUSD mnUSD mn
SourceInternational Monetary FundInternational Monetary FundInternational Monetary FundInternational Monetary FundInternational Monetary FundInternational Monetary FundInternational Monetary Fund
StatusDiscontinuedDiscontinuedDiscontinuedDiscontinuedDiscontinuedDiscontinuedDiscontinued
Series ID2.6E+082.6E+082.6E+082.6E+082.6E+082.6E+082.6E+08
Last Update Time#################################################
12-19967290.2215627.40799.44262.321125.5811709.00340.24
01-1997   260.061091.53 241.71
02-1997   229.961053.74 260.13
03-19976931.79 748.68258.661160.87 300.77
04-1997   262.621109.59 292.10
05-1997   271.091160.51 287.95
06-19977269.05 778.15244.441117.17 310.96
07-1997   271.421014.84 312.90
08-1997   254.221030.25 295.87
09-19976757.52 747.10221.461121.26 337.36
10-1997   272.191264.57 315.67
11-1997   242.941310.69 284.18
12-19978022.0516817.30789.13273.881253.2413688.40322.80
01-1998   228.991128.11 299.40