Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Merging rows that have same value for a visualization

Hello, I have a table that its main value are "Key Numbers" this "Key numbers" have a topic which I call "Epic Names" an "Epic Name" can have several Key Numbers. Is there a way to have different row...
  • edhans's avatar
    edhans
    4 years ago

    Is this what you need? If not, I'm going to ask you to read the "how to ask for help" section below, because I cannot use images for data, and it helps to have a result you've mocked up in Excel as to what you want.

     

    I return this:

    This can be done using Group By with the Advanced optoins.

     

    If that is not what you want, please read below - especially the "how to provide sample data" section

    How to get good help fast. Help us help you.

    How To Ask A Technical Question If you Really Want An Answer

    How to Get Your Question Answered Quickly - Give us a good and concise explanation
    How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.