Slicer Dropdown not showing all values

[DougM]

Hi

We have started experiencing an issue where not all values are showing in multiple filter dropdowns - you can consistently scroll down and the list stops at the same place, in the example we are using it stops at B ...

• Using the slicer search for C then populates the list with all values after B or
• Hitting the Refreah button results in the full list being show

However, once you leave the report and then go back to it, the same issue is encountered

I have tried republishing with Persistent Filters set to Off - no change. We are accessing an Analysis Services tabular model via a gateway

Any suggestions appreciated

Thanks

Doug

[v-danhe-msft]

Hi @DougM,

Based on my test, it could work on my side:

If I misunderstand you, could you please offer me more information about your problem?

Regards,

Daniel He

[DougM]

Thanks, but the problem persists. It looks like a buffering issue i.e. only a portion of the tabular dimension is loaded to the slicer - note position of the slider bar in image below i.e. it look like the end of the dataset (Image 1)

Hitting refresh, or using the search bar "forces" the rest of the data to be loaded (Image 2)

Regards

Doug

[v-danhe-msft]

Hi @DougM,

Could you please share some sample file to have a test?

Regards,

Daniel He

[DougM]

Sorry Daniel, will not help as the backend is an on-premise Analysis Services tabular model .. Appreciate your help

Regards

Doug

[v-danhe-msft]

Hi @DougM,

Is the slicer you are using is the Smart Filter by OKViz? 

Regards,

Daniel He

[DougM]

Hi Daniel

No, it is the standard PowerBI Slicer

Regards

Doug

[v-danhe-msft]

Hi @DougM,

I could not understand the sentence you have posted "Using the slicer search for C then populates the list with all values after B".
I have tested leave the report and go back to it, it still could work on my side:

Could you please offer me more information?

Regards,

Daniel He