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.
Good morning, I need your help. I have generated a matrix table shown in the photo. As you can see from the dataset I have two values (E and I) for the same code associated with a specific week number (26). How can I display them both within the matrix table? I attach a screen to facilitate understanding of the scenario
Screen2. Dataset
Screen1. Matrix Table
Hi @Carlend ,
Yes, this problem does exist because the ‘Value' label in the matrix need aggregate fields.
So you may need to consider using table visual.
Or use @harshnathani 's formula to combine the text values.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Carlend ,
You can try this measure
Measure =
CONCATENATEX (
FILTER (
'Table',
'Table'[N_Week]
= MAX ( 'Table'[N_Week] )
),
'Table'[Fase_EXMNT],
","
)
Regards,
Regards,
Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |