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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
rebeccam
Helper I
Helper I

Matrix with qualitative values by date

Hello!

 

I have a data base that has: date, farm and logistics operator.

I want to creat a matrix that shows me which logistic operator worked in a farm, on the days of the month.

BUT, in some days I have two different logistics operator working in that farm. AND, when I create a matrix, it only brings the first or the last value.

I want to creat a table that shows me all the logistic operator working in a specific farm, and the dates in the columns.

Do you know how to make it in the matrix on Power BI, or if I have to use another "chart/matrix/table"?

 

Sorry for bad english.

1 ACCEPTED SOLUTION
AlB
Super User
Super User

Hi @rebeccam 

You can use a measure as: 

Measure =
CONCATENATEX (
    DISTINCT ( Table1[Logistics operator] ),
    Table1[Logistics operator],
    ", "
)

 This will show all the names separated by a ", "

Please mark the question solved when done and consider giving kudos if posts are helpful.

 

 Cheers 

 

SU18_powerbi_badge

View solution in original post

3 REPLIES 3
AlB
Super User
Super User

Hi @rebeccam 

You can use a measure as: 

Measure =
CONCATENATEX (
    DISTINCT ( Table1[Logistics operator] ),
    Table1[Logistics operator],
    ", "
)

 This will show all the names separated by a ", "

Please mark the question solved when done and consider giving kudos if posts are helpful.

 

 Cheers 

 

SU18_powerbi_badge

Thank you so much, @AlB !!

 

I've created the measure as you suggest, than I unchecked format > column header > scale automatically to have it down.

 

Matrix.JPG

rebeccam
Helper I
Helper I

Matrix.JPG

Adding image. In day 1, I had 2 TOVER and RAMPAZO in Santo Antônio, but the matrix does not show it.

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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