Forum Discussion

Brett007's avatar
Brett007
Helper III
6 years ago
Solved

Filter Table Fields

I have a Table with 95 Columns The Rows are easily filtered by on screen slicers How do I filter the columns based on a selectable list?   Thank you
Need Help
Tips and Tricks
  • dm-p's avatar
    dm-p
    6 years ago

    Hi Brett007,

    Table columns (fields/measures) don't have a filter context like rows do. It's not currently possible to do this without using measures or changing the structure of your data, and will certainly depend on whether your requirements can work with such an approach (particularly the data types).

    There are a couple of references I can provide you to see if it might be something you could try (in order of simplicity):

    Hopefully this should give you some ideas. Good luck!

    Daniel

    If my post solves your challenge, then please consider accepting as a solution to help other forum members find the answer more quickly 🙂

dm-p's avatar
dm-p
Super User
6 years ago

Hi Brett007,

Table columns (fields/measures) don't have a filter context like rows do. It's not currently possible to do this without using measures or changing the structure of your data, and will certainly depend on whether your requirements can work with such an approach (particularly the data types).

There are a couple of references I can provide you to see if it might be something you could try (in order of simplicity):

Hopefully this should give you some ideas. Good luck!

Daniel

If my post solves your challenge, then please consider accepting as a solution to help other forum members find the answer more quickly 🙂