Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
amaoa
Helper II
Helper II

Multiple Assignments Shown Due to Multiple Resources in a Table Visual

Hello,

I created a table to list assignments. But whenever the assignment has two or more resources, it shows up twice or based on the number of resources assigned to the assignment in the table. I know this makes sense as not all resources might finish assignment at the same time. Any idea how I can make it show just once? This is throwing off the count of assignment completed or ontrack. I also don't want to show it twice in the table. See example below. Data source is from Project Online. 

 

image 1.png

3 REPLIES 3
amaoa
Helper II
Helper II

I found out. I went to transform data. Right-click the Mapping Name column and select Delete Duplicate Data. Thank you all.

Hi @amaoa , 

 

I'm glad that you solved the problem by yourself. Would you please accept your own reply as answer to help the other members find it more quickly?

 

Best Regards,

Dedmon Dai

dedelman_clng
Community Champion
Community Champion

Hi @amaoa 

 

Since the data in the two rows is different aside from the task name, you have to apply some kind of summarization to the date fields (and possibly the % complete) to knock it down to 1 row.

 

Summarizations available for dates are Last (Latest), First (Earliest), and Count. Which one you use depends on what you are trying to show.

 

Hope this helps

David

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.