Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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
Solved! Go to Solution.
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
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