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

ruisadias — Tue, 21 Jun 2022 15:16:49 GMT

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

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

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

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

ribisht17 — Tue, 21 Jun 2022 15:58:49 GMT

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