Forum Discussion
Helper IThird party table object with filter into column header
Hi all,
There's someone how find a third part table that allow to filter directly from column header instead to use a slicer foreach column?
BR,
M
Hi MattiaMaetini ,
It is actually possible to do this, but I don't really consider it a "clean" way.
- edit the query
- duplicate the table you want to filter based on columns
- select all the columns you want to be able to filter (using shift and or control)
- right-click and select unpivot data
- now you can filter based on the new "attributes" column
Notice how this is not a good suggestion for large data as you have to copy the entire table.
Below is the post will help you:
Solved: Filtering by column headings - Microsoft Fabric Community
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi MattiaMaetini ,
It is actually possible to do this, but I don't really consider it a "clean" way.
- edit the query
- duplicate the table you want to filter based on columns
- select all the columns you want to be able to filter (using shift and or control)
- right-click and select unpivot data
- now you can filter based on the new "attributes" column
Notice how this is not a good suggestion for large data as you have to copy the entire table.
Below is the post will help you:
Solved: Filtering by column headings - Microsoft Fabric Community
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.