I had the same problem with my data and I resolved that using story instead of dashboard.
In story option,you can exclude certain column without affecting the main worksheet.
Thank you, Sankar. This is really helpful.
Is there any way to do this where the parameter is automatically assigned to specific dashboards? Say I were to make a Provider dashboard and a Patient dashboard. Can I have parameters automatically show up for those certain dashboards?
No. parameter is the end user selection one. if you need to create separate dashboard for each title then create or use then single dashboard to get all sheets.
Is there any way to re-size columns dynamically? The NPI is blank for the patient, but it's still a significant chunk of the table. Can I have it resize depending on what is selected?