Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.