Forum Discussion

mpagan's avatar
mpagan
New Member
3 years ago

Repeating fields

Good day!

 

I created a report showing multiple points of data for our facilities. I get repeating facility names. How do I "group" so it shows only one name per row? This field is common in all tabs in the spreadsheet. 

 

I tried searching but I am new to PowerBi and I don't know what it's called.

 

 

Thank you in advance for your help.

6 Replies

  • VijayP's avatar
    VijayP
    Community Champion

    mpagan 

    apart from the first column what other columns are ! They are also causing repetition! 

    for example in your data for Wichita , there are two different records are then then it will show as duplicate only!

    Share the sample data to see what exactly it is causing and then solution!

    • mpagan's avatar
      mpagan
      New Member

      These are all the data points the facilities are being measured against. Each tab on the workbook is a different metric.

       

  • VijayP's avatar
    VijayP
    Community Champion

    mpagan 

    then the required result is not possible! because each one column represent different data!

    • mpagan's avatar
      mpagan
      New Member

      So how would I create a visual showing all the different metrics for a facility?

      • VijayP's avatar
        VijayP
        Community Champion

        @ you must create them separately , or by combining them(if it can be ?) and use as a single point of truth!