Forum Discussion
Power BI Table
Hello, I need help with 2 requests. I have a table as below in Power BI. Ocean Carrier - database field Type - calculated column based on origin-destination Container ID - da...
lbendlin
Super User
Super UserFor 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