Matrix Visual with Show on rows doesn't immediately update when using drillthrough filters

[clausm73]

I have a made a Power BI Report which uses drilltrough filters on a customer name.

When drilling from another report or simply just manually choosing a value in the drillthrough filters properties in Power BI Desktop  - all but one visualisations on the page updates accordingly. The matrix visualisation on the page doesn't update until AFTER the user has set focus on another report page and then setting focus back to the drillthrough report page.

But this is ONLY a problem with "Show on rows" set to ON. If "Show on rows" is set to OFF the matrix visual updates immediately when selecting/unselecting a customer in the drillthrough properties area.

Power BI Desktop - Matrix Visual - Show on rows ON - NOT immediately updating

Power BI Desktop - Matrix Visual - Show on rows OFF - DO immediately update

Does anyone has a solution - or is this a bug?

[v-jiascu-msft]

Hi @clausm73,

Seems fine in my test. Are there any other conditions?

BTW, please upgrade the Desktop to the latest version.

Best Regards,

Dale

[clausm73]

The underlying data model uses a snowflake schema.

[Sales Budget] - fact table containing the column being aggregated (Volume).

[Contract Periods] - dimension table with headers related to a specific sales budget per customer account.

[Accounts] - dimension table with customer information.

The [Sales Budget] table is in reality a Fact-Dimension table with exactly one row for each sales budget for each customer contract period. To the auto-created relationship is a One-to-One relationship with a two-way filter direction (Filter direction = "Both").

And I expect this One-to-One relationship is the problem.

I want the [Sales Budget] to be filtered by the [Contract Periods] that again are filtered by the [Accounts] table. But changing filter direction on the One-to-One relationship isn't possible - so filters coming from [Accouns] and [Sales Budget] has equal priority. This is actually a security issue because [Accounts] has Row Level Security - but [Sales Budget] numbers are displayed for non-allowed accounts even though they are filtered by RLS.

The strange part is that this is NOT an issue when "Show on rows" is NOT used. Then the RLS filter on Accounts get propagated correctly - and correctly identifies that the filtered customer has NO [Contract Periods] rows and NO [Sales Budget] rows.

[clausm73]

A small recording displaying the missing filter propagation in a matrix visual with "Show on rows".Power BI Desktop - Matrix Visual - Filtering problems