- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Dynamic Column Names in a table visual for a measure
Hello Everyone,
I am new to PBI and am having trouble in getting the below done.
Want to dynamically name the measure name from the output of the calculation.
I have table visual with 5 measures, and I want to be able to rename them dynamically. Please See the screenshot below, where I have hardcoded the column names but I want them to be dynamic.
say my DAX reads
YEARNUMBER=YEAR("March 3, 2020 3:45 PM") and the result is 2020 and i want the measure name to be 2020 INSTEAD of YEARNUMBER.
Any help is really appreciated.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

What you can do though, is create just one measure which will also take into account the selected year, and use a matrix visual, adding 'Year' in columns.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Anonymous ,
As mentioned above, when you put data in Table visual, the field name will be the table column header name. It can't be changed dynamically, you could submit this in ideas .
If you want to column show it based on date, you could chage your data structure(power query , unpivoy your data) like below(put name in Row, year in Column, amoun in Value in Matrix, then column name is 2018, 2019, 2020)
name year amout
a | 2020 | 2 |
a | 2019 | 3 |
a | 2018 | 5 |
b | 2020 | 2 |
b | 2019 | 6 |
b | 2018 | 3 |
If possible could you please inform me more detailed information(such as your expected output and your sample data )? Then I will help you more correctly.
Please do mask sensitive data before uploading.
Thanks for your understanding and support.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Anonymous ,
As mentioned above, when you put data in Table visual, the field name will be the table column header name. It can't be changed dynamically, you could submit this in ideas .
If you want to column show it based on date, you could chage your data structure(power query , unpivoy your data) like below(put name in Row, year in Column, amoun in Value in Matrix, then column name is 2018, 2019, 2020)
name year amout
a | 2020 | 2 |
a | 2019 | 3 |
a | 2018 | 5 |
b | 2020 | 2 |
b | 2019 | 6 |
b | 2018 | 3 |
If possible could you please inform me more detailed information(such as your expected output and your sample data )? Then I will help you more correctly.
Please do mask sensitive data before uploading.
Thanks for your understanding and support.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

What you can do though, is create just one measure which will also take into account the selected year, and use a matrix visual, adding 'Year' in columns.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Anonymous
I am not sure if It is possible to do so but, you can create a measure that shows all the years selected and show in a card visual above the table or use the Visual Title to include the dynamically selected values using Conditional Formatting.
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
I accept KUDOS 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Join our Community Sticker Challenge 2025
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Subject | Author | Posted | |
---|---|---|---|
07-27-2023 11:26 PM | |||
08-27-2023 04:18 AM | |||
02-20-2024 07:12 AM | |||
08-16-2018 07:18 PM | |||
05-28-2024 04:06 AM |