Column Stuck Selected; Can not filter other columns keeps jumping back to original selection
I have a data sort which requires me to apply a couple different filters in the data view. When I open the report I select the first column and apply a filter on my table in data view.
Whenever I select the filter button on the next column it automatically is hoping back to the last column I selected not pulling up the filter dropdown on the new column. This is a new issue as of last night and I can not seem to select any column for filtering other than the first one I click on when entering the data view.
I have tried uninstalling and reinstalling powerBI but no luck
24 Comments
I have the same issue after update to the lastest version, could be problem in this version
Seems like could not reproduce it in my side as far as my test. When I have updated Power BI Desktop to the latest version(2.108.603.0), the filter works fine on the data view and allowed to filter multiple columns as expected:
Perhaps you can consider providing some screenshots or .gif pictures which could reproduce this issue, or try to use the previous version of Power BI Desktop to check the same issue again:
Previous monthly updates to Power BI Desktop and the Power BI service - Power BI | Microsoft Docs
Regards
I am having the same issue. Super frustrating.
Same issue here.
Anonymous - I think this issue does reproduce in your screenshot (but has no effect because you only have 3 columns) - in the screenshot you are opening the filter in 'Value' column, but 'Date' column is still selected (highlighted in yellow).
When there are more columns with horizontal scroll, when scrolling to a column that is off-screen and opening the filter drop-down, the page snaps back to the selected column, making it impossible to filter.Same issue
Anonymous Yaa_D I think you are right on with your comment. In your screenshot the date column highlights/selects when you pick the dropdown on value still. For this issue if you were to open BI table select date and filter it and then left click on the value column to select it then hit the dropdown the selected column would still jump back to date column.
This is okay with three columns because you can still see the filter window but on a table with many columns where the first is not visable on screen it is returning the view to the original column so the next column is not filterable.
As a short term work around for everyone else; the only way I got it to take a new column selection without jumping back when the filter button was used was to hide then unhide the column with a right click. Super tedious but if you are looking for something short term.
Having same issue
Same issue here. It is a pain to work like this.
Same problem here. Here goes a video showcasing what is happening
https://sharing.clickup.com/clip/p/t3084050/7e351d73-ee8b-4c46-95b4-1843144f4c7a/screen-recording-2022-08-11-11%3A17.webm
How to replicate the issue:
0 - Make sure you are on the July or august version of PBI;
1 - Go to Data view;
2 - Select a table;
3 - Filter the first column (actually you dont even need to filter , just open the menu);
4 - Go to any other column further away and try to filter it;
5 - You will be sent back to the first column that you had touched, so if the columns are too further apart you cant use them both.
The thing is , if you witch to another table and come back , it works... so you have to keep switching tables if you want to apply multiple filters to a table.
