Thank you Mynda. I'll look into the hyperlink idea. Mike
Mynda, besides using the expand/collapse buttons, which are useless while the chart is locked; is there any way to have a user switch between the cate...
Hi Mynda Yes, that helped. I removed the table in the dashboard workbook and reworked the power query in the Data workbook to feed the data model. ...
Hmmm...If I click Refresh All in the Dashboard workbook with a table data cell selected It updates the table data, and if I select a pivot chart in th...
Hi Mynda, I have a dedicated data workbook and I then use a query to update the data table in my dashboard workbook. I use power pivot to create t...
Thank you Mynda! Your power pivot table will be super helpful in guiding my way forward in this project. Thanks again for taking the time to help m...
I will check out the power pivot solution if the following cannot be done using the basic pivot table. Attached is new data with a daily returns colum...
Hi Mynda Upon opening the workbook you sent, I see a 2022 percent change for SPY as -74.20%. I don't believe this calculation is correct as the S&a...
Thank you Catalin for your response. At this point I don't think I am even asking the right questions to achieve my dashboard goals. I have a lot to l...