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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
nlakshmi
Frequent Visitor

Power BI Table

 

Hello,

 

I need help with 2 requests. I have a table as below in Power BI.

 

nlakshmi_0-1677253049340.png

 

 

Ocean Carrier - database field

Type - calculated column based on origin-destination

Container ID - database field

Start and Dest Units - Calculated measure based on count

Status - database field

 

Request 1: For the first 2 rows, the Carrier and Container ID are the same but Type is different. Is there a way to combine the two rows to show the Type as "Multiple" and total the counts?

Request 2: Again, for the first columns, because the Container ID is the same, is it possible to show the Status as "Open", because there is a value in the Start Units column? The logic is, if there is a count in the Start Units for the same container ID then show Status as "Open".

 

Thank you very much your help!

5 REPLIES 5
lbendlin
Super User
Super User

For Request 1:  Use the built in grouping function of the table or matrix visuals

For Request 2: Add an aggregation "Max of Status" as an implicit measure to your visual.  Since "O"  comes after "C"  this will show "Open"  wherever that appears in a group (container)

Thank you very much lbendlin.

The solution for Request 2 is exactly what I needed. Thank you!

For Request 1 though, when I group on Type - while it works for instance of rows 1&2, for the remaining rows also, the group label shows "Export & Domestic" - which is incorrect. Is there a way to conditionally change the label to the actual if multiple values do not exist. i.e show "Multiple" only if there is Domestic and Export for a container Id, else show actual.

 

Thank you

I can't understand how that would look like. Can you please indicate the expected outcome based on the above sample data.

Thank you lbendlin, for the response.

When I group on the Type column, here is what I get:

 

nlakshmi_2-1678214620434.png

 

Rows 1 & 2 were rolled into a single row and rightly so. But for rows, 3 -6, the Type still shows "Domestic & Export", which is incorrect.

 

What I'm trying to achieve though is:

nlakshmi_3-1678214700949.png

 

Thank you for your time!

see attached

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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