Forum Discussion
Filter by table content or expand into single cell
Hello all, still learning Power BI and had I am facing a challenge
I am using XML and expanded my tables to get my desired data. When visualizing, I'd like to filter by content nested into a table. Like such:
I want to avoid expanding this column since it will cause me to have too many rows and skew my other results. but when using filters, I can only see [Table].
A possible solution would be if I could expand into its own cell so I'd have "Cloud Agent, Cloud Agents, Masterlist - January 2018, Non-Production Servers" all concatenated into one line. I could then perform keyword filtering, I'm just not sure if Power BI has such feature built in?
Any options achieving this would help me greatly
Thanks!
Hi Hankyone,
Please have a look at below similar threads:
Filtering a Power Query Table Based on a Column That's a Table
Best regards,
Yuliana Gu
1 Reply
- v-yulgu-msft
Microsoft Employee
Hi Hankyone,
Please have a look at below similar threads:
Filtering a Power Query Table Based on a Column That's a Table
Best regards,
Yuliana Gu