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