Forum Discussion

Hankyone's avatar
Hankyone
Regular Visitor
8 years ago
Solved

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!