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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
CloudMonkey
Post Prodigy
Post Prodigy

Changing table column name using variable

Hello,

 

I have a column which I've renamed "Year to Date" in a table visualisation. If I set a variable somewhere to May is there a way to program the column heading to be "May YTD" (i.e. put the month name in automatically)

 

Thanks for your help,

 

CM

1 REPLY 1
Ruksuro
Helper III
Helper III

I don't beleive this is possible to make dynamic for the end-user as it is defined at load stage.

 

I would recommend adding a new measure which returns a string which you can then use as a title, either in the visual itself or on a card above.

 

I don't know your specifics but something like:

 

Title = if(hasonevalue([Month]),min([Month])&" YTD","YTD")

 

 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.