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