Interactive Dashboard question

Hello,

After pulling in a report to a dashboard using a report widget, I am unable to interact with the dropdown cells in that report. Additionally if I publish the report and get the URL, then use a web widget to populate the dashboard, the report is in Read Only.

How can I still retain the functionality of the interactive dropdown cells within the report from the dashboard? 

Thanks

Answers