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, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
KenCBowman
Advocate I
Advocate I

Filter Pane Loses Selection when Selecting Multiple Items Using Search with Apply Button

Hi,

When using the Apply button with the Filter pane, as you search for and add selections to the filter, previously added selections are lost. This occurs in the latedst release of Power Bi Report Server (January 2021 version 15.0.1105.230).

 

For example, if I have Orange County selected in my County filter, I can search for and add San Diego County, which enables the Apply button. If I then search for Riverside County, San Diego County disappears from the list (although if I hit Apply at this point, it will be filtered) and Riverside appears (unselected) in the list. If I then select Riverside County and hit Apply, only Orange County and Riverside are selected in the filter. 

 

Filter Pane Search and Apply Issue - 1.pngFilter Pane Search and Apply Issue - 2.png

 

 

 

 

 

 

 

 

 

 

 

 

 

Searching and selecting when using the Apply button will only add the last selected item to the filter.

 

This fuctionality works correctly (i.e., selections are not lost as you add more) in Power BI Desktop optimized for Report Server (2.88.2361.0 64-bit).

 

Any help would be appreciated.

 

Thanks,

 

Ken

12 REPLIES 12
rohanjaiswal
Frequent Visitor

I am also facing the same issue.

I have also have single Apply button for all my filters.

Also noticed that when multiple items are selected and if you scroll through the list and only last selected values retained into selection. 

v-deddai1-msft
Community Support
Community Support

Hi @KenCBowman ,

 

I can't reproduce your issue. It works well based on my test:

 

1.png

 

Best Regards,

Dedmon Dai

Hi Dedmon,

 

Thank you for taking the time to try to replicating the issue. Can you please verify the following, as I am experiencing this issue on two different servers (I was able to replicate on my dev what my users are experiencing on our production server):

 

  • Are you using the latest version of Power BI Report Server (i.e., 15.0.1105.230)?
  • Do you have the "Add a single Apply button to the filter pane to apply changes at once" option enabled?
  • Are you using a long enough list (like counties) where you have to search in order to add the next selection (there isn't an issue if the list is short enough to display all options or you are picking off multiple selection from the same search criteria)?

Again, this works fine in Power Bi optimized for Report Server(2.88.2361.0 64-bit).  

 

Thanks,

 

Ken

Hi @KenCBowman ,

 

  • Are you using the latest version of Power BI Report Server (i.e., 15.0.1105.230)?
  • Do you have the "Add a single Apply button to the filter pane to apply changes at once" option enabled?
  • Are you using a long enough list (like counties) where you have to search in order to add the next selection (there isn't an issue if the list is short enough to display all options or you are picking off multiple selection from the same search criteria)?

Yes , all the things are the same to you. But I still can't reproduce your issue. All the things work well. Would you please check if you have click apply button after you select more items every time.

 

1.png

 

Best Regards,

Dedmon Dai

Hi Dedmon,

 

Yes, the Apply button is enabled as I add selections to the filter, however, I am not applying after each selection. I'm trying to search for and select several items before hitting the Apply button to reduce the number of queries sent to the server.  This is what is not working in Report Server, but is in Power BI Desktop optimized for Report Server. 

Thank you for continuing to look at this,

 

Ken

Hi @KenCBowman ,

 

Yes, I test it in the report server. If you could provide us sample pbix with the issue?

 

Best Regards,

Dedmon Dai

Hi Dedmon,

 

I can create a pbix, but the issue isn't the data or the model.

 

I've noticed that in both of your screenshots that you do not show having multiple items selected prior to hitting the Apply button. Your screenshots show multiple items filtered and searching for one item... which works fine.

 

What is not working is having an item filtered (e.g., see Orange County in the screenshot below) and then adding multiple items (e.g.,  Los Angeles, San Diego and Riverside counties) before hitting the Apply button.

 

Filter Pane Search and Apply Issue - 3.png

 

This screenshot was done in Power BI Desktop optimized for Report Server. I have found that the issue is intermittent in that application.

 

Can you confirm that you can have an item filtered and then search for and select multiple items before hitting the Apply button?

 

Thanks,

 

Ken

Hi @KenCBowman ,

 

Sorry for misunderstanding your issue. I can reproduce your issue. It seems that when we use search bar and apply icon, we could only add one selection for one time.

 

Best Regards,

Dedmon Dai

Hi Dedmon,

 

To clarify, this query reduction feature works correctly only in certain instances when selecting multiple items to filter on.

 

For example, if there are no items currently filtered, you can search for and select multiple items without losing the previous selections or having to hit Apply after each selection. It stops working correctly once there is an item that has been filtered.

 

For now, I'm removing the Apply button from my dashboards as it is too confusing to explain to my users that it will only work correctly in certain instances or that they have to hit Apply after every selection (which defeats the purpose of query reduction). Hopefully it will be fixed in a future release.

 

Thanks,

 

Ken

Hi @KenCBowman ,

 

So as a workaround, you should select the first option “Instantly apply basic filter changes” in the Power BI desktop for RS.

 

Best Regards,

Dedmon Dai

Hi @v-deddai1-msft ,

 

But itsn't selecting the instant apply will request multiple queries to the server..? 

Like for every selection of items  it will send a separate request. which will impact performance it dataset is too large.

Yes, that's what he's saying. Its not really a workaround. The new feature doesn't work to reduce queries when selecting multiple items, so its best not to use it (at least if you don't want your users getting confused).

 

I'm hoping they fix it, becasue it would be a great way to improve performance.

 

Ken

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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