Forum Discussion
several filters on the same column
- 4 years ago
If the filters for each column should be dynamic for the end user you should load the table to the data model and use slicers so the user can select their own filters. If the filters should be automated for the next report but they will be the same filters, you can still select them manually and Power Query will write the script for you so your selections are retained when the report is refreshed.
If this does not answer your question please provide more information on the expected outcome/scenarios.
If the filters for each column should be dynamic for the end user you should load the table to the data model and use slicers so the user can select their own filters. If the filters should be automated for the next report but they will be the same filters, you can still select them manually and Power Query will write the script for you so your selections are retained when the report is refreshed.
If this does not answer your question please provide more information on the expected outcome/scenarios.