Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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):
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 🙂
Proud to be a Super User!
My course: Introduction to Developing Power BI Visuals
On how to ask a technical question, if you really want an answer (courtesy of SQLBI)
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 🙂
Proud to be a Super User!
My course: Introduction to Developing Power BI Visuals
On how to ask a technical question, if you really want an answer (courtesy of SQLBI)
User | Count |
---|---|
88 | |
74 | |
69 | |
65 | |
58 |
User | Count |
---|---|
104 | |
94 | |
76 | |
62 | |
59 |