Forum Discussion
Helper IHelp removing duplicate headers in power bi table
The answer was to use a matrix, move the text "columns" to Rows, remove the +/- sumbol, then click on the icon that will expand all levels. It works perfectly!
Solution SageCan you take a screenshot of how you're adding this to the matrix, as well as the place(s) you changed the data type? I don't think this is a flaw in power bi. I've never not been able to change a field to text.
Helper IIt already IS text. Unquestionably. It is a varchar field in the database and it shows as Text in the BI Query. It's like Excel does with using the first set of rows to determine the data type, and unless you tell Excel not to do that, it interprets a number like an Invoice number as a number, even if 20 rows later they are all alphanumeric, and probably a third of the invoice numbers in the data are alphanumeric.
I changed the data type to Text even though the BI query already knows it's text and this is what I get: No matter what I do in a matrix. the invoice numbers go across the top as though there were column headers.
This doesn't work. But what ALSO doesn't work is the fact that, if I make this a Table, the vendor names are duplicated for each invoice. I guess my users will have to get used to seeing the vendor names duplicated, but that's a shame.
Any other suggestions? I'd really appreciate being able to resolve this.