Filter by table content or expand into single cell

[Hankyone]

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!

[v-yulgu-msft · Accepted solution]

Hi @Hankyone,

Please have a look at below similar threads:

Filtering a Power Query Table Based on a Column That's a Table

filter nested table rows

Best regards,

Yuliana Gu