Filter Table Fields

[Brett007]

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

[v-lionel-msft]

Hi @Brett007 ,

I agree with @dm-p 's answer.

Best Regards,
Lionel Chen

[dm-p · Accepted solution]

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 🙂