Slicer working on one date field but not another of the same type

[SLMR]

Hello,

i have a simple power bi report:
Just a table with invoices and two date fields "datum" (date of invoice) and  "bezahlt_am" (date the invoice was payed).
I created a dimension Table dimKalender.

If i create a relation bettwenn the date filed of the dimKalender and the invoice table "datum" field, the slicers i placed on the report work as they should:

The table is fitlered by the "datum" column
If i do exaclty the same with the "bezahlt_am" column, it is not filtering if i choose a specific year.

And if i select a specific Quarter the table just does not display any values at all.

Any idea why the slicers work on one date filed and not the other?

[Anonymous]

Hi @SLMR 

On this issue I would like to confirm the following to you:

1. Is the “specific year” field you are putting into the slicer from the “DimKalender” table? Are you trying to create a one-to-many relationship between the “bezahlt_am” column and the date column of the “DimKalender” table, and then filter the “cr8ec_rechnung” table by the “year” field of the “DimKalender” table?
2. Did you create two relationships or did you modify the columns connected to the calendar table in the first relationship? If you are creating two relationships then I agree with @Joe_Barry , please follow Joe_Barry to active the second relationship as only one active relationship can exist between the two tables(As shown in the screenshots below). You can also refer to Solved: How to force or make a measure to use the relation... - Microsoft Fabric Community
3. If the issue is still not resolved, please provide more details of the problem and screenshots related to the issue and remember to protect data privacy, this is a public forum.
4. For the model relationships please refer to Model relationships in Power BI Desktop - Power BI | Microsoft Learn

^{Best Regards,}

^{Jarvis Tang}

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

[SLMR]

Hello,

1: it ist from dim calender.

2: No it is only one relationship.
3: I onyl created one relationship bewtween dim calender and "bezahlt_am". Nothing special. I do this all the time. As the fitlering did not worked with this relationship, i just tryed to use another date-column. And with this relationship everthing workd as it should.

So i can not see why it does not work with the column i want.

- The data come from dataverse.  The only difference with the columns is that "datum" is buisness required, while "bezahlt_am" is optional. So this column has null values as long as the invoice is not payed.
 

[Joe_Barry]

Hi @SLMR 

create a one to many relationship with the bezahlt am column. This will be an inactive relationship.

you then need to create a measure.

TotalBezahltAm =
Calculate( [Betrag_Netto], Userealtionship( 'Date'[Datum], 'Table'[BezahltAm]))

this will activate the relationship with Bezahlt am  Spalte.

hope this helps

Joe