Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
docdata
Regular Visitor

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 values.  IAServiceSplit splits this column on the comma into new rows.  A bidirectional filtering many:1 relationship exists between these two tables.

(if a "contains" slicer or list-type column existed, this model setup wouldn't be needed)

docdata_0-1728591414098.png

 

 

I'm using a Paginated Report visual that takes in Account ID as a parameter (allow multiple values, no default values, no "Available Values", automatically determine when to refresh) to filter a PR visual of accounts and their attributes.

 

There are Industry (IAServiceSplit[Industry Associations]) and Ultimate Country (account[Ultimate Country]) slicers.  In a regular table/matrix visual, the list of Account IDs is properly filtered (accounting for both slicers).  This is also confirmed by the list of available Account IDs to filter on for the PR visual.  This interaction also works as expected for the rest of the PBI report.

docdata_1-1728591468665.png

docdata_2-1728591532863.png

 

 

However, the PR only accounts for a single slicer.  If IAServiceSplit[Account ID] is used for the PR parameter, only accounts affected by the Industry Association slicer show, and if account[Account ID] is used for the PR parameter, only accounts affected by the Ultimate Country slicer show (example below).

docdata_4-1728591603104.png

 

The desired result is both slicers to create a smaller subset of Account IDs to be used for the final PR filter.  I tried to create a calculated table

 

INTERSECTION(
    ALLSELECTED(account[Account ID],
    ALLSELECTED(IAServiceSplit[Account ID]
)

 

 but the resulting table isn't calculated post-slicers.

3 REPLIES 3
v-xianjtan-msft
Community Support
Community Support

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.

 

vxianjtanmsft_0-1728633045076.png

No slicers applied:

vxianjtanmsft_1-1728633119598.png

Apply the first slicer:

vxianjtanmsft_2-1728633159600.png

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

vxianjtanmsft_3-1728633185741.png

 

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.

 

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.

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]
    )
)

vxianjtanmsft_0-1729216140854.png

 

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.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.