I am facing issues in dealing with dashboard actions with multiple measures.
Dashboard has two different worksheet:
1. text table which has Branch Name and multiple measures ( Total Sales, Total Customer, Total Marging, Growth % )
2. Month on Month table which has line graph plotted on above mentioned measures.
Now, when i click on dashboard measure Total sales, action should be able to give me line graph of sales Mom. If i selected customer from text table then MoM table should get changed to Customer MoM.
Basically, i have text table which is giving me consolidate figures for multiple measures and i i want to do MoM for that particular measure without using any external parameter and want to achieve using dashboard actions.