dinamic column name change - each record has different columns in different places - two tables

[ruisadias]

Hello everyone, 

I am trying to find a way to dynamically update the column header names in a tabular table visual .

I have two tables each with a Rate that is the relationship between both ; and 5 column ( col1 , col2 , col3 etc..)  

One table has , per each Rate , the names of the columns related to that Rate. 

Other table, per Rate , has the values of such columns. 

Each one can have any number of records/columns filled in.

So i would want , when i change the filter, so that the Names of the columns be updated 

Names Column

RATE	COL1	COL2	COL3	COL4	COL5
11	Country	Postal Code
22	Volume	Quantity	Company	Country	City

Data Column ( multiple records per Rate, just simplifying it with just one record) 

RATE	COL1	COL2	COL3	COL4	COL5
11	UK	fv1423
22	10 CBM	11	ABC company	Germany	Berlin

Final Result wanted

When filter has rate 11

RATE	Volume	Quantity	Company	Country	City
22	10 CBM	11	ABC company	Germany	Berlin

When filter has rate 22

RATE	Country	Postal Code
11	UK	fv1423

Hope i was able to explain 

Thank you in advance 

[ribisht17 · Accepted solution]

@ruisadias 

Solved: Dinamically change table dimension - Microsoft Power BI Community

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users