I suggest you to attach the workbook.
Here's the workbook. So, the dashboard filters work for sheets that were generated from fields that I didn't pivot (i.e. Region and Years Worked). However, when I try to filter using a sheet created from the pivoted field (such as amount of work or confidence in business), everything goes wonky. I suspect I am either doing filters wrong, or I am not using the pivot correctly to create the charts. Of course, it could be both! If yall have a suggestion for how I can better use pivoted data, please share - I see many people advocate using pivoted data for surveys, but it feels clunky so I think I'm doing it wrong.
survey_analysis_final_fight2.twbx 172.5 KB