Filter drop down in Analyze in Excel

Hi Cherry,

Consider the following dataset:

I entered this table in PowerBI desktop and published it to Power Bi Service.

The Analyze in Excel pivot then shows:

Note 'VAL SUM' is a SUM Measure of 'VAL'

Let's say I want to see 'A' in ATTR1, then the pivot looks like:

However now, if I filter on ATTR2, I see:

Since ATTR1 is filtered on 'A', we should ideally be seeing only 'B' and 'P' in the ATTR2 filter drop down but we see all the values.

It looks like the all of the values is being fetched from the dataet since it is an OLAP data source. This is not the behaviour when the data is present locally in the Excel file itself.

Since our reports contain hundreds of thousands of values in such attributes, we face a severe performance issue while using the Analyze in Excel. Using the search box in the filter drop down also performs bad.

I have used slicer to show filtered data however since the slicer doesn't have a search box, it doesn;t work well for us.

Hope this makes this clear.

Thanks!