Forum Discussion
Solved
filter across multiple columns
Hello, how can I filter the data and display all that contain an "X" and write the data in a new Table Regards Stefan
There are various methods.
Try this methods ...
In Power Query select the Check ID , Status and Bereich column
Then Transform > Unpivot > Unpivot Other columns
Then filter the rows that have "X"
Learn how here
https://learn.microsoft.com/en-us/power-query/unpivot-column
Hi stefantaust
The solutions provided by above are both valid and should help you achieve the result:
- The Power Query method using Unpivot Other Columns and then filtering for "X" is great if you want to handle this at the data transformation stage.
- The DAX measure approach works well if you prefer to control the logic in your report visuals using a measure-based filter.
I’d suggest giving these methods a try. If you still face any issues or need help adjusting them to your exact setup, feel free to post back and we’ll be happy to support further.
Best regards,
Akhil