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

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.

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
Super User
Super User

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


@ 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!:
The Definitive Guide to Power Query (M)

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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