Relationship & Data Issue

[emperkins]

I'm new to working with Power BI relationships. 

I have four separate tabs in a spreadsheet, all of which have a date column formatted by Month/Year. 

I created three separate relationships: lavendar date column to dark blue date column, lavendar date column to orange date column, and lavendar date column to purple dark column. All of these relationships are active, with one to one cardinality and cross-filtered in both directions. 

Everything is displaying correctly except for the October data. The October numbers are correct, but Power BI is adding an extra line before October 2020 with three of the values. (See bottom table) At times, I also get a weird, wider space between the December 2020 and January 2020 bars on the bar chart. The spreadsheets/source data have not been changed at all. 

[Anonymous · Accepted solution]

Hi @emperkins ,

Based on my testing, try to copy four tables into the power bi desktop.

Drag the column into the matrix visual to see if the problem still exists.

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Does your data model have a designated Calendar/Dates table?

[emperkins]

It doesn't. It won't allow me to designate a date table. It keeps saying there are gaps in values, even though there are no null values and it's continguous months/years from 2016 through 2024. 

[lbendlin]

Create your own then, for example via CALENDAR() . Or better yet, use an externally prepared reference table, as that data is immutable and there isn't really a need to compute that Dates table over and over again.

[emperkins]

I was able to create the data table, but I'm still running into this issue only for the month of October.