Showing results for 
Search instead for 
Did you mean: 
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 🙂

Community Support
Community Support

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.





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.

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.


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

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors