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

How to set measure name when select dimension?

Hi 

 

I have attached the one treemap view chart below.

In That i have created Actual and budget measures using below expression. vMapseletion variable when user select in filter in actual it show the actual value and user select budget it show the budget value.i can able to  get the values correctly. 

=pick(Match($(vMapselection),'Actuals','Budget'),
Num(Sum({<[Budget Type Code]={'Actuals','Actual'}>}Expense))
Num(Sum({<[Budget Type Code]={'Budget'}>}Expense))

 

My Requirement is need to change the measure name based on selection.

ex if user select budget it show the budget value it is fine.same time need to show that value name is budget.if select actual it show actual name.

 

1 Reply
vikasmahajan

Hi ,

 

Go to measures - Under Label type following formula

=pick(Match($(vMapselection),'Actuals','Budget'), ' Actual','Budget')

 

Hope this helps you

 

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.