Forum Discussion

docdata's avatar
docdata
Frequent Visitor
2 years ago

Paginated Report visual insensitive to multi-table slicers

An account table and IAServiceSplit table exist in my model.    IAServiceSplit is effectively a duplicate of the account table.  account has a column of type list with multiple comma separated valu...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi docdata 

 

According to your description, I think it's because the Paginated report visual can't take into account multiple filters from different slicers at the same time when processing a single parameter.

Please consider adding two parameters to your Paginated report and mapping them to the IAServiceSplit[Industry Associations] and account[Ultimate Country] fields respectively when creating the Paginated report visual in Power BI Desktop.
This way the slicers for both fields will be applied to your Paginated report visual.

 

No slicers applied:

Apply the first slicer:

Paginated report visual applies the filtering of both slicers at the same time:

 

Please refer to this link about Paginated report visual: Create and use the paginated report visual - Power BI | Microsoft Learn

 

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

docdata's avatar
docdata
Frequent Visitor
2 years ago

The PR itself doesn't take in any of the slicers.  The slicers reduce the Account IDs in IAServiceSplit and account, but the PR visual only accounts for the filters applied to the source table for Account IDs.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi docdata 

     

    Sorry for the late reply.

    My test results are consistent with yours. If the PR visual only takes the Account ID as a parameter, the PR visual will not be able to satisfy both slicing choices like the Table/Matrix visual, even if the Account ID Calcultion Table created satisfies both slicing conditions.

    FilteredAccounts = 
INTERSECT(
    SELECTCOLUMNS(
        FILTER(
            ALLSELECTED(account),
            [Ultimate Country] IN VALUES(account[Ultimate Country])
        ),
        "Account ID", account[Account ID]
    ),
    SELECTCOLUMNS(
        FILTER(
            ALLSELECTED(IAServiceSplit),
            [Industry Associations] IN VALUES(IAServiceSplit[Industry Associations])
        ),
        "Account ID", IAServiceSplit[Account ID]
    )
)

     

    If you're a Pro account, you can create a support ticket for free and a dedicated Microsoft engineer will solve the problem for you.

    How to create a support ticket in Power BI - Microsoft Fabric Community

     

    Thank you for your understanding.

     

    Best Regards,
    Jarvis Tang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.