Forum Discussion
Issue with Data Slicers in Paginated Report
Hi Team,
I'm encountering an issue with data slicers in our paginated report that I need your assistance with. Currently, I have a Fact Table linked to two different date tables: Date[Table1] and Date[Table2].
In the report, I've crafted several graphs and tables, some of which utilize Date[Table1] while others depend on Date[Table2].
The problem arises when attempting to filter visuals and tables differently using datasets in the report builder. Despite employing the same dataset and slicers, I'm experiencing discrepancies and data loss. Notably, there are no conflicts with edit interactions, and the table maintains a one-to-many relationship.
To elaborate, using one date slicer for all visuals functions correctly. However, when introducing another date slicer alongside the existing one, certain visuals, unrelated to the first slicer, suffer from data loss or discrepancies.
It's worth mentioning that when running the paginated report offline, it operates seamlessly with both slicers. However, upon publication, the aforementioned issues arise.
Could you please advise on the best approach to incorporate both data slicers effectively in our paginated report?
Looking forward to your guidance on resolving this matter.
Ahmedx Ritaf1983 amitchandak parry2k lbendlin
Best regards,
1 Reply
Hi imnewpbiuser568 ,
First of all I think you need to make sure that you have set up the report parameters correctly to filter the data in Date [Table 1] and Date [Table 2]. You can check out the following document: Create parameters for paginated reports in the Power BI service - Power BI | Microsoft Learn
Secondly I think you need to optimize the query for the dataset and of course sometimes it is necessary to use a simplified model which helps in querying the data.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
