Forum Discussion
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 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
2 Replies
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.
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?
