Intuitive way to navigate to multiple alternative measures

[chaorenzhu]

Hi, 

Basically I have multiples bar charts with the same dimension and the only change is the measure used. Instead of plotting a lot of repetitive charts I want to present it more neatly. I know there is alternative measure but the users don't like it as they find it difficult to choose the desired measure among multiple measures. I'm thinking of using buttons and link each button to an alternative measure, but couldn't find such solution. Any one can advise how can I achieve that (may not be button, could be any other solution as long as it's an intuitive way to click some easily noticeable icon to switch to a different chart with the same dimension but different measure?

Thank you!

[abhijitnalekar · Accepted solution]

Hi @chaorenzhu,

You can do this by using the variable input component 

and use the expression for the chart as below.

=if(vyeart='1T',
Sum([#TransactionCount]),

if(vyeart='2S',
Sum([#RPTGrossAmount]*ConvertRate),

if(vyeart='3A',
(Sum([#RPTGrossAmount]*ConvertRate)
/Sum( [#TransactionCount]))

))))

[chaorenzhu]

Thanks a lot! Very helpful trick