Formatting selected measure

[Rolandas_T]

Hello,

I have button controls which select aggregated measure to display in the crosstab. I can pre-select number format of this measure in the left pane but the problem is that this measure can be number of percentage (eg. average claim, loss ratio, etc.). Is there a way to select format of this selected measure dynamically? Few screenshots attached for the mental picture. Any ideas and workarounds are welcome.

Rolandas

[Rolandas_T · Accepted solution]

Solved it by creating different button control for each measure.