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.
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.
I'm not sure I am following this but perhaps concatenate the name and date into a unique key?
@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.
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 |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |