Link to home
Create AccountLog in
Power BI

Power BI

--

Questions

--

Followers

Top Experts

Avatar of Anna M
Anna M🇬🇧

PowerBi Visualization

Hi, I am having issues to align data in a visual on PowerBi, The highlighted numbers are 1 customer but is been duplicated as the data is not aligned. How can I avoid duplicates if is the same data? 


Is there a way to see the milestones in one single line instead of one milestone per row? User generated image


Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.


Avatar of David H.H.LeeDavid H.H.Lee🇲🇾

..Is there a way to see the milestones in one single line instead of one milestone per row?

You can use group by  aggregator function to filtered out the result instead.

User generated image

More information:

https://learn.microsoft.com/en-us/power-query/group-by 


Avatar of Anna MAnna M🇬🇧

ASKER

Thanks so much for answering. I don't need one single value I need them all in one row (aligned) as the dates are stages of projects. Let me know if you know how to do this please thanks so much


You just need to group your existing 4 fields below:

...GroupBy OSC Ref, Segment Level, Primary Business Type, RAG Status


Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.


ASKER CERTIFIED SOLUTION
Avatar of Anna MAnna M🇬🇧

ASKER

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account
Power BI

Power BI

--

Questions

--

Followers

Top Experts

Power BI is a business analytics tool from Microsoft used for data visualization. It integrates seamlessly with other tools, like Microsoft Excel, and is easily embedded in websites and apps. Power BI offers live dashboards and visual reports to help “bring your data to life.” There are many opportunities for customization, as well as built-in options for your visualizations and analytics. With the Power BI mobile app, you can receive push notifications about important data changes, allowing you to react and plan right away.