Forum Discussion
Solved
Issue in filtering
I have a common date filter on the report. The report by default it is showing yesterday date data without any date filter select. However, if the customer selects a specific date, the visuals should...
Thanks, everyone! Creating a bridge table helped me resolve the issue.
When you face a situation like this—where the visual doesn't use aggregate measures—consider building a bridge table. It allows the correct context to flow through and resolves filtering issues effectively.
There is no metrics just columns city from x, date from dimdate, address,notes and installations status from y.
Hi chaitanya1 ,
Make sure that tables X and Y have rows for the dates you are selecting from DimDate[Date]. If there’s no data in X or Y for that selected date, the table will go blank.
Check also that DimDate[Date] is properly related to the date column in table Y (or X, depending on where your main data lives).