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!
Most Valuable ProfessionalThe columns in a matrix aren't meant to display text values like that - they either add column headers (e.g. years across the top) or summarize values (e.g. sum of amount). You might be able to mimic it by making a measure that takes the min or max of the invoice number if you put that into values, though. There will only ever be one value, so it's kind of a dummy measure, but it wants to be doing "math" in the values well regardless.
Helper IThat's an interesting suggestion. The Invoice numbers are never duplicated. I can try that, though it seems like a lot of effort to get this to work.
- christinepayton
You don't even really have to create a measure per se... I think if you drag in the invoice number into "values" it'll probably auto-summarize with a count or sum unless you have summarization disabled. You can click the field in the visual pane to swap it to a different summarization.
- KarenGrube
It defaulted to "First" summarization, which didn't work.