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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors