User selected dimension

[#1]

Hi,

Is it possible to let the user decide which dimension to show in a visualization?

I have a combo chart with two axes with lines representing two different KPIs. What I want to do is to let the user choose which KPI they want to compare by clicking on a filter view or dropdown or similar. If not, is there some other pattern to visualize this? There will be 2^2 different combinaions of kpis to compare so it's not feasible to create different combo charts for every one of them.

Thanks

Viktor

[jagan]

Hi Viktor,

Did you tried this, without using the extensions.

LOAD one table with Measures like Sales, Gross margin, Gross margin%, and use this expression in chart

=Pick(Match(Only(Measure), 'Sales', 'Gross margin', 'Gross margin%'), Sum(Sales),, Sum(Sales) - Sum(CostPrice), Sum(Sales)/Sum(CostPrice))

Hope this helps you.

Regards,

Jagan.

[#3]

Hi

take a look at this there is a sample app with it.

Cyclic Dimension in Sense

Regards