Forum Discussion
Solved
Combine Filter Columns into 1 Dynamic filter or slicer
Hi fellow PBI users, I have been struggling with this for a while and not found an answer. I hope someone will be able to help me with this. My goal is to have a single filter or a slicer that a...
Hi jilee ,
Please select columns A, B and C simultaneously in the Power Query Editor, then unpivot these columns.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I believe this solution works if you are working with factual data, however, if the intention is to work with dimensional tables, this will break relational model.
Wondering if there is any solution with hasonefilter or some trick to make filters from different dimensional (lookup) tables work with 1 selector.
Thanks