Forum Discussion
Filters on All Pages Not Filtering all Pages
One page of my 50 pages is not filtering. Data comes from "Policy" Table.
I have a Filters on all pages using Report Group which is in LossRun table.
My Main Table is LossRun.
Policy Table is Connected to BPD - Many to One and Single Cross Filter.
and BPD is Connected to LossRun - Many to One and Single Cross Filter.
Any idea on what I need to do?
4 Replies
Hi bdehning - Can you please share some more details by uploading your sample file in drive? so that it helps to understand the model.
Unfortunately, the database is too complicated and date sensitive to upload sample data file. I end up with X and Y Asix for two pages that provide counts, where the other 48 pages gets counts from another table. I can only connect the two tables Many to Many and that has not solved my issue. My filters which are columns from main table have no affect on the counts from the secondary table. Could I add a Column to either table or both to create a one -to many relationship?
Please share a simplified version of your PBIX file (in English) without sensitive data. You can upload it to a public cloud service like OneDrive, Google Drive, or Dropbox and share the link. This will help in understanding your data structure and the issue, allowing for more precise guidance.
Hi bdehning ,
Unable to reproduce your problem, please provide more details, such as a sample file with the same problem. Are you applying filters for all pages using the Filter toolbar?
If the Policy table filtered well on other pages, I recommend you refresh the report.
Best regards,
Mengmeng Li
