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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Flyism
New Member

No email data from 2020 in 2021

Hey everyone, 

 

i developed a dashboard that shows how well your emails are performing (different measures etc.) and it worked perfectly in 2020. I work with two tables. The first one is filled with email data (name, total sendings etc.) and the other one is just data describing these emails (type, topic....) 

 

My problem is that i cant find any data from mails created in 2020 in 2021. Some mails were sent multiple times, therefore i should have data in 2021 even though the first sending was in 2020. It only shows the new mailings created after 1.1.21

 

I appreciate any advice. Thanks 🙂

3 REPLIES 3
V-pazhen-msft
Community Support
Community Support

@Flyism 
Seems like a filter or slicer problem caused by inappropriate relationship.

A few question, how is the date table used and how do the 2 tables related? It would be best if you can provide a sample.

 

Regards
Paul

 

 

amitchandak
Super User
Super User

@Flyism , difficult to tell without some example data .

Check your tables what are the dates is showing.

If you using a date table; make sure it has all dates.

 

Check if some join is failing, because on of the date has timestamp

 

Any other filter like year at visual, page or report level.

pranit828
Community Champion
Community Champion

Hi @Flyism 

Do you have a date filter in your dataset? 

Check that, hopefully it has 1/1 and current year hardcoded.





PBI_SuperUser_Rank@1x.png


Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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