cancel
Showing results for 
Search instead for 
Did you mean: 
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 IV
Super User IV

@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.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

pranit828
Super User II
Super User II

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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors