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.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Pfin ,

 

This seems to be an unsupported feature. What I can think of is that the table originally had these columns, and then filtered by slicer to filter the table data.

 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.