Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
ap08rock
New Member

Need Dynamic title name in table view column

Greetings to all, I trust you're all in good health. I'm currently endeavoring to make the column header in my table view dynamic based on the selected date filter. To achieve this, I've employed a parameter and devised the following formula:

`
Parameter = (
MAX('Date'[Year Date].[Year]) & " LTM",
NAMEOF('LTM measure'[TY LTM]),
0
)
query.png

This formula is indeed functional, but it provides the maximum year from the available data. What I'm aiming for, however, is to have the header display the current year based on the selected date value. I've attached a screenshot for reference and would greatly appreciate your guidance on this matter.

1 REPLY 1
Anonymous
Not applicable

Hi @ap08rock ,

 

According to your statement, I think Parameter should be a column instead of a measure.

As far as I know, Power BI doesn't support column to be dynamic.

Your demand is a good idea, while it is not supported to implement in Power BI currently.
You can vote up this idea for this function:
Or you can submit a new idea to improve the Power BI.
It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

Best Regards,
Rico Zhou

 

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

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.