Forum Discussion

estelter's avatar
estelter
Regular Visitor
8 years ago

Highlighting Specific Data & Updating Original File

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 an...
General Comment
Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

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's avatar
estelter
Regular Visitor
8 years ago

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?