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
IanCockcroft
Post Patron
Post Patron

Dynamic Column names not updating

Hi  guys,

I'm using parameters to dynemically  change a columns name based on the slicer selection.

I have created a measure to display the slicer selection for debugging and it displays correctly in a card visual.

when i drop   the measure into the paramers DAX, i expect   the column header to   change..

it does   not. I am expecting the  column heading to be "2023-05 YTD Actual"

 

parameter code:

Dynamic Fields = {
    (SELECTEDVALUE('CC EB'[Period])&" YTD Actual", NAMEOF('Calculations'[PY YTD Actual]), 0)
}

 

what am i missing?

thanks guysCapture.JPG

1 ACCEPTED SOLUTION
IanCockcroft
Post Patron
Post Patron

I did manage to get this right, if anyone is interested.

But there is a caviate.

you need to know all the possible options in a slicer.

in my case, it is year-month period slicer. so 12 a year

e.g. for 1 year, the parameter table will have 12 entries calling the same measure, but each line has the specific label for the month.

Capture.JPG

add another column that links to the period/date table. it needs to be many to many link so date table filters parameter table

bit of a work around but the client is thrilled.

 

PM me if i can assist.

Ian

View solution in original post

3 REPLIES 3
IanCockcroft
Post Patron
Post Patron

I did manage to get this right, if anyone is interested.

But there is a caviate.

you need to know all the possible options in a slicer.

in my case, it is year-month period slicer. so 12 a year

e.g. for 1 year, the parameter table will have 12 entries calling the same measure, but each line has the specific label for the month.

Capture.JPG

add another column that links to the period/date table. it needs to be many to many link so date table filters parameter table

bit of a work around but the client is thrilled.

 

PM me if i can assist.

Ian

amitchandak
Super User
Super User

@IanCockcroft , I think you are changing the code of the Field Parameter table. That will not work. As tables are static in nature. they will take a value with selectedvalue and get loaded. and will not get new data till the next data refresh. This means you can not use slicer value in calculated table and column

If you want to check the selected value field parameter take for order field and based on that you get field parameter value

What is selected = maxx(filter('Axis Slicer', 'Axis Slicer'[Axis Slicer Order]= SELECTEDVALUE('Axis Slicer'[Axis Slicer Order])),'Axis Slicer'[Axis Slicer])

 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thanks Amit

so basically its not possible?

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.