Forum Discussion

KarenGrube's avatar
KarenGrube
Icon for Helper I rankHelper I
3 years ago
Solved

Help removing duplicate headers in power bi table

I've asked a similar question to this which was resolved by using a Matrix in Power Bi.  However, in that case, instead of Invoice Number, there was a text column.  In this case, the Matrix seems to ...
Need Help
  • KarenGrube's avatar
    KarenGrube
    2 years ago

    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!

KarenGrube's avatar
KarenGrube
Icon for Helper I rankHelper I
3 years ago

That'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's avatar
christinepayton
Icon for Most Valuable Professional rankMost Valuable Professional
3 years ago

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's avatar
    KarenGrube
    Icon for Helper I rankHelper I
    3 years ago

    It defaulted to "First" summarization, which didn't work.