three table filter

[bincat]

Hi!

I've this scenario, three tables joined by IdCentro-IdReserva

My problem is when i filter Produccion's Fecha (Date) with a slicer, as you can see Produccion is Filtered OK, Reserva is Filtered OK buuuuut FacturaHotel IS NOT filtered -> KO

if I filter Reserva by Fecha(Date) then it filters FacturaHotel correctly.

comment -> In data not all rows in FacturaHotel has Row in Reserva

Any idea, is very simple but i'm ofusced 

Thank's in advance

[v-yuezhe-msft · Accepted solution]

@bincat,

Does the bridge table Reserva contain all the possible IdCentro-IdReserva values in FacturaHotel and Produccion tables? If not, it will not display expected result when using slicer.

If Reserva table contains all the possible IdCentro-IdReserva values in FacturaHotel and Produccion tables, when you use Fecha field of Produccion  table to create slicer, the Reserva visual will show all  IdCentro-IdReserva values in the selected data range, and the FacturaHotel  visual will show relevant IdCentro-IdReserva values with other fields according to the filtered IdCentro-IdReserva values in  Reserva visual . If you still have questions about the filter result, please share sample data of the three  tables for us to analyze.

Regards,
Lydia

[bincat]

Hi and thank's

The problem is all values in Reserva are in Produccion, all values in Reserva are in FacturaHotel gbuuuuuut

all values in Produccion are not in Reserva, all values in Produccion are not in FacturaHotel

all values in FacturaHotel are not in Reserva, all values in FacturaHotel are not in Produccion

Now i understand the problem but conceptually,

if you slice Produccion all values wich can be reflected in Reserva should be reflected (and it does) and all Reserva reflected values should be reflected in FacturaHotel following the join direction (it doesn't) ?

[v-yuezhe-msft]

@bincat,

Only if Reserva contains all the possible IdCentro-IdReserva values of Produccion and FacturaHotel tables, the relationship would work as you describe when you slicer  Produccion .

Regards,
Lydia

[bincat]

Thank you very much