Forum Discussion

lazy_anarchist's avatar
lazy_anarchist
Frequent Visitor
2 years ago

FIlter based on columns

I have few tables, they have column names which end with seasonal,not seasonal. for example: in an employment table. I have column names:Nation - All Employees, Total Nonfarm_Not Seasonally Adjusted...
Need Help
Tutorial Requests
parry2k's avatar
parry2k
Icon for Super User rankSuper User
2 years ago

lazy_anarchist it is possible, you need to tweak your table in PQ, unpivot the columns, and then create another column to get anything after "_" . Create another table with the options for slicer and set relation of this new table with the newly created column.

 

Once this is all done, you can easily filter your data tables using the slicer, and ofcourse slicer will use this newly created table.