Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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,
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
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) ?
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
Thank you very much
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |