Highlighting Specific Data & Updating Original File

[estelter]

Hello,

I have a few questions I am hoping to receive assistance with...

Is it possible to highlight data in the queries? Say for example I have the same custom ID tied to two different people and want to flag this how can I do this?

How do I update a file that I have multiple graphics already tied to?  I tried to update one file with a newer version, but had issues with differing header labels. However, I fixed the data headers and the new data would still not load correctly.

Why does the column always say 'First' when added into a data set featuring graphics. --> e.g. First Safety Specialist

[Greg_Deckler]

Not entirely sure of a couple of your questions. You can do a remove duplicates in your query. You could also do a count and identify custom ID's that have a count of two.

I don't understand your second question.

First is a default aggregation, I think generally for text. You can change the aggregation.

[estelter]

Hello, 

thanks for responding.

relating to my second question, 

Say for example I have a large set of data that I am breaking out individually by regional manager, so the file would look like:

manager           store         contract    

ryan                  xbv              8924

matt                 ulk                9083

carrie                mnb               3278

if I then changed Matt and Carries contract numbers and reuploaded the file in power BI, will the broken out files update as well in power BI?