Forum Discussion

Pfin's avatar
Pfin
Frequent Visitor
2 years ago
Solved

Power BI - Dynamically Change Column Name

I'm trying to take the data from Tables 1 & 2 to create a report based on selected Make/Model.  The challenge is that each Make/Model has 3 fields for general value adjustments.    In order to keep...
Need Help
  • danextian's avatar
    danextian
    2 years ago

    Hi   Pfin 

    Power BI doesn't allow dynamic renaming of columns in visuals, unlike Excel. A workaround involves creating a table with all potential column name and value combinations and utilizing a slicer to filter the displayed columns based on user preferences. This approach provides a flexible solution, though it's important to note that there isn't a universal fix for this issue. I've discussed this in detail in a vlog.

     

    https://www.youtube.com/shorts/CHEneTrZav0 

    https://www.youtube.com/watch?v=8U88ZRMsCI8&ab_channel=PowerBITambayan

     

    The link to a sample pbix is posted on the video description.

     

danextian's avatar
danextian
Super User
2 years ago

Hi   Pfin 

Power BI doesn't allow dynamic renaming of columns in visuals, unlike Excel. A workaround involves creating a table with all potential column name and value combinations and utilizing a slicer to filter the displayed columns based on user preferences. This approach provides a flexible solution, though it's important to note that there isn't a universal fix for this issue. I've discussed this in detail in a vlog.

 

https://www.youtube.com/shorts/CHEneTrZav0 

https://www.youtube.com/watch?v=8U88ZRMsCI8&ab_channel=PowerBITambayan

 

The link to a sample pbix is posted on the video description.