Forum Discussion

IanCockcroft's avatar
IanCockcroft
Post Patron
2 years ago
Solved

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 guys

Need Help
  • IanCockcroft's avatar
    IanCockcroft
    2 years ago

    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

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    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's avatar
    IanCockcroft
    Post Patron
    2 years ago

    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