Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ruisadias
Frequent Visitor

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

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

RATECOL1    COL2    COL3        COL4COL5
11CountryPostal Code   
22VolumeQuantityCompanyCountryCity

 

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

 

RATECOL1    COL2    COL3        COL4COL5
11UKfv1423   
2210 CBM11ABC companyGermany

Berlin

 

 

Final Result wanted

 

When filter has rate 11

 

RATEVolumeQuantityCompanyCountryCity
2210 CBM11ABC companyGermany

Berlin

 

When filter has rate 22

RATECountryPostal Code
11UKfv1423

 

Hope i was able to explain 

Thank you in advance 

 

 

1 ACCEPTED SOLUTION
ribisht17
Super User
Super User

@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 

View solution in original post

1 REPLY 1
ribisht17
Super User
Super User

@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 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors