Could you please attach packaged workbook? (**.twbx)
It's quite difficult to understand background of necessity of so many measures..
Sorry, I can't. But the situation is this:
I have 5 measures (the are filled with numbers) DOB1, DOB2, DOB3, DOB4, DOB5.
If the user select "Feb 18" (in a Parameter), the alias for the measures should be:
DOB1 = Feb 18
DOB2 = Jan 18
DOB3 = Dec 17
DOB4 = Nov 17
DOB5 = Oct 17.
If the user select Jan 18, the alias now should be:
DOB1 = Jan 18
DOB2 = Dec 17
DOB3 = Nov 17
DOB4 = Oct 17.
DOB5 = Sep 17.
It seems easy for you to create sample data ?
Shinichiro, here you have.
I need the following:
When I select a Month/Year the alias have to change dynamically.
For example, If I select Jan/2018
The red bar "MY Selected" has to say "January 2018".
The blue bar "MY Selected -1" has to say "December 2017".
The blue bar "MY Selected -2" has to say "November 2017".
The blue bar "MY Selected +1" has to say "February 2018".
Measures Alias.twbx 13.9 KB
I solved this using calculated fields (one for each measure I want to change alias dynamically), I hide measures' alias and put below the chart the calculated fields.
Hi, I have the same problem I have 4 measures T0 T1 T2 and T3
these represent time and I would like to change the alias dinamically basing on a paramenter.
When the reported period is 2016 then I wan to T0 be 2016 T1 be 2017 and so on.
When the reported period selected through the paramenter is 2017 I want T0 be 2017 t1 2018 and so on.
Could you show the steps to compute this?