Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi community
I have 2 tables :
1. table "A" : contain [Policy No]
2. table "B" : contain [Channel]
and both of table have a one-many relation :
A (*) <- (1) B
but when I create "Matrix" visualization which contain [Policy No] in row and [Channel] in value (first value)
I found that [Channel] show first of all B table that is "Agency" in every row of [Policy No]
,not show first values by row.
Are there anyways to show the first value of [Channel] by [Policy No] rows in "Matrix" visualization?
Please Help me.
Thank a lot for answer.
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!