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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

 

Thanks Amit

so basically its not possible?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors