Forum Discussion
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, Nation - All Employees, Total Nonfarm_Seasonally adjusted. there are few columns like this. I am plotting a line graph. I want to have an option to select only seasonally adjusted columns or not seasonal. So when I select seasonally adjusted I only display columns ending with seasonally adjusted.
Thank you.
1 Reply
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.
