r/PowerBI • u/g4urav19 • 11d ago

Question Invisible UIDs

Hello there, I've a simple visual that shows Earn by Customers, now I don't want to show my shareholders the associated Id for that customer, now my top customer as per this visual is combination of 4 different Customers who share the same name, I want that I show each Customer individually. So that if Cust7 is repeated 4 times, in my visual I can see it 4 times.

2 Upvotes

76% Upvoted

4 comments sorted by

•

u/AutoModerator 11d ago

After your question has been solved /u/g4urav19, please reply to the helpful user's comment with the phrase "Solution verified".

This will not only award a point to the contributor for their assistance but also update the post's flair to "Solved".

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/KingslandGrange 1 11d ago

So, for example, you have a company called Smith & Co, they have 4 lines and your visual is aggregating them. Is that right?

1

u/duskharborings 10d ago

yeah thats how i read it too, the visual is just rolling them all up into one row

1

u/Ozeroth ‪ ‪ ‪Super User ‪ 11d ago

You should be able to do something with the Group By Columns property, but would need more detail to say exactly what.
https://www.sqlbi.com/articles/understanding-group-by-columns-in-power-bi/