Way to create a graph using two drop down menus?
I am wondring if there was a way such that after selecting two different items from drop down menus, a graph with the information requested is displayed.
I have four measures; Coffee Gross sales, Coffee Net profit, Tea Gross sales, Tea net profit. I want to be able to select any two of these and have a graph be displayed.
The hard part: It has to be able for use on a website.
Thank you for your time to help me with this question.
1. Re: Way to create a graph using two drop down menus?
Yes this is possible. You can use a parameter to swap different fields and show the chart with different dimensions or measures. This will give a read-only viewer a way to explore different dimensions.
Download the training solutions workbook and go to the last example.