Forum Discussion
Dynamically Change 'measure' name
So, I ended up changing the names of the measures in the field parameter to remove all the FORMAT(...). I included a couple more columns to categorise them in measure type and what week each measure is looking to. I imported a support table with the dates I needed, giving them the name that I want to display, what category of week they belong too and I crossjoined that with the field parameter table.
It looks great except... Now the order of the parameters is not dependant on the order you click the fields to include. Which I am trying to solve because I think it's a nice to have.
But just in case that's not an issue for somebody, I would probably say this is the solution
Hi.
This can't and definitely *shouldn't* be done imho.
Imagine a user has selected July and -1 week. If the user then switches to August, the second selection should still be -1 week and not change to a value with a new date.
Exactly, that's why I mentioned that I didn't realize it worked as a calculated table and won't refresh with filter changes. I think this method is only useful with cases as the video.
I'm wondering if there are any alternatives that may help my situation,