Forum Discussion
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
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):
- BI Elite - Dynamic Columns in a Table
- Community Blog - Dynamic Hideable Columns in Power BI Table Visual
- Phil Seamark - Dynamic Columns based on values
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 🙂
2 Replies
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):
- BI Elite - Dynamic Columns in a Table
- Community Blog - Dynamic Hideable Columns in Power BI Table Visual
- Phil Seamark - Dynamic Columns based on values
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 🙂
