Repeating fields

[mpagan]

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.

[VijayP]

@mpagan 

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

[mpagan]

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

[VijayP]

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

[mpagan]

Well hopefully another superuser has figured out a way and will see my post.

[VijayP]

@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]

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