Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Advocate II
Advocate II

Why does the relationship not work anymore?

2017-03-28 14_19_19-311-dashboard - Power BI Desktop.png

To make it easy to switch time ranges I created selector that let you select among 6 “temporalities”:  this week, this month, this year etc…


It is based on 2 extra tables, one, called “Calendar”  that associates each date with the relevant 6 temporality it can be associated with; and a relationship table that contains all the dates and is associated with the dates in calendar on one side and with the event date in the fact tables (actually with 2 dates, the open date and the close date, hence the 2 lines, one dotted, below)


2017-03-28 14_22_26-311-dashboard - Power BI Desktop.png


This worked like a charm until I refreshed the data this morning.

I did not change anything to the data model.

The only thing I did is removing the use of USERELATIONSHIP with 2 measures and remove/restore relationships in the project (at some point there was a glitch in the data load that suggested there might be an issue with those metrics).

But today everything is restored as it was yesterday so I don’t understand why

  • The Calendar to AllDates relationship works
  • The Fact table to AllDates relationship works
  • The Fact table to Calendar relationship does not work anymore

Again, it worked as expected; I could pick a temporality from the Calendar table and filter on the related subset in the fact table.


What could have possibly happened?

Responsive Resident
Responsive Resident

Hi @osinquinvdm,


is it possibly down to the cross filtering direction on the relationship. 


The 1 to many direction would suggest that the alldates tables filters the table containing the temporalites and not the other way around. 


I'm wondering if data refresh has changed the relationship dynamics? 


what are the from and to columns on the relationship?




Hi @osinquinvdm

Which relationship do you remove in your data model? Are you unable to filter your visual in the case? If that is the case, please share sample data of your tables and detailed DAX you use to create measures for us to analyze.

Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

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!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors