I have a simple concept of a dashboard that would change the measure on a graph based on which sheet on the dashboard is selected. I've done my googling and can't find something that works exactly like I need,
In the attached image, I have four sheets, each with one measure and the % change from the previous period. I'd like to make it so when an end user clicks on a sheet, it changes the measure in the trend graph on the right. Currently I have a parameter and calculated field entering the selected measure from the parameter into the graph worksheet (see the dropdown at the top right).
If parameter actions aren't the way to go or if anyone has a better idea of how to do this, I'm open to any feedback/help.
Hi @JW Barnard​, this is what you have to do,
a. Create a calculated field each for 'New Patient', wRVU, Payment, and %Internal cases depending on how you set each up in the parameter.
b. Drag each calculated field to the detail of their respective worksheet.
c. go to Dashboard and set up 4 parameter actions, using each of the calculated fields as the source field to update the parameter value.
I hope this is helpful. You can also share a sample workbook if the above isn't clear enough.
