Forum Discussion
XML Import - Table Type in Column
Hi brittany,
Here are some useful links about parameters and slicer for you reference.
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-tutorial-slicers/
If this is not what you want, please provide us some sample data and expected result, so that we can make further analysis.
Regards,
Charlie Liao
Hello, thanks.
I have looked at those, but am unable to get them working with my 'Table' data. I'm not sure what I'm missing.
To be clear, this is an XML import, and working with a column that has 'Table' cells in it. When I attempt to use this column, for example as a filter, all that appears is:
O (blank, i.e. nothing)
O [Table]
Inside the [Table] is the actual data, as described in my original post - but all I get is brackets with the word Table in the middle. As stated originally, I presume I will need a helper column, but cannot find anywhere how to reference or extract data from a Table cell - on either the query side or the report side. All I can do is look at it on the query side, as clicking on such a cell displays the contained data (successfully) underneath the grid.
Thanks