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.