Dynamic Column names not updating

[IanCockcroft]

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 guys

[IanCockcroft · Accepted solution]

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.

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]

@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])

[IanCockcroft]

Thanks Amit

so basically its not possible?