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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

Columns help in Matrix visual

I'm using the Matrix view to display where recipients click in our emails. Some times we have emails that share the same name but are sent on different dates (As can be seen in the screenshot below, A and B versions). Currently, if I manually change the date in the data source to be the same for all A/B version emails they fall under the same column. But i would like them to do that without having to manually manipulate the data

 

What am I missing here..?

 

Thanks in advance.

 

Overlay-powerbi.PNG

 

 

 

 

 

 

 

filter-powerbi.PNGlink-powerbi.PNGconnections-powerbi.PNG

2 REPLIES 2
Greg_Deckler
Community Champion
Community Champion

I'm not sure I am following this but perhaps concatenate the name and date into a unique key?



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable


@Greg_Deckler wrote:

I'm not sure I am following this but perhaps concatenate the name and date into a unique key?


Hi Greg. Using a unique key sounds like the oppososite of what I'm after though. In the example below I manually changed the date (in the source data file: 1_Overlay_Links) for the A version to be the same for both sendouts. The B version still has two different send dates and is therefore in two different columns. I want them to be displayed in one column according to name without having to change the send dates.

 

I don't know why it splits on send date as I have not included any date filters in the visual.

 

Overlay2-powerbi.PNG

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors