Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

0

From select all to multiple selection

Hello, 

i have few slicers (below). In right item no., in left prod.orders. When i select item i.e. 1007, in other slicer i see related prod.orders. Because there are a lot of orders i want to select them just in one click, so i turn on "Select all" and deselect unnecessary blank values. So far so good, but next when i deselect item no., my slicer with prod.orders select all orders instead showing related orders to item no. 1007. Why? 🙂 

Fiksavimas.PNG

Status: Delivered
Comments
v-haibl-msft
Microsoft Employee

@AntanasK

 

I cannot repro the same issue on my side using June 2017 version of Power BI Desktop and Power BI Service. Please refer to the gif below and let me know if there is any difference between our repro steps. If possible, you can share your PBIX file through online file service like OneDrive.

 

From select all to multiple selection.gif

 

Best Regards,
Herbert

Vicky_Song
Impactful Individual
Status changed to: Needs Info
 
AntanasK
Advocate I

https://1drv.ms/u/s!Aq8aNyHn90QmgjodcGjclrMD-JWs

 

here's my file with couple items and related orders and LOT no. First i select item no. 1007, then my slicer 

filters prod.orders. (in real database there's more than 30 orders per item). So i push select all, deselect

blank value, deselect item no. and after that power bi select all orders. 😞

If i select orders manually (multiple selection), and then deselect item no., power bi leaves my selection. 

Next the same situation with LOT no. I want to select related LOT no. in one push, but must select all manualy, deselect prod.orders, and finally get my last result. 

How to force pbix select related selection instead all entire selection? Hope that i explained situation

understanable.

Thank you.

AntanasK
Advocate I

Any ideas?

v-haibl-msft
Microsoft Employee

@AntanasK

 

Please refer to below recorded video. Do you mean that when deselect '1007', no change should happen in the table visual and the 'order no' slicer?

If yes, I do not think it is reasonable. Because the item slicer can filter other visuals (including slicer and table), when you deselect the item in 'item' slicer, the other visuals will become unfiltered.

 

From select all to multiple selection_1.jpg

 

 

Best Regards,
Herbert

AntanasK
Advocate I

First thank you for your time. Yes, no changes should happen when deselect item no. When i deselect item no, slicers select all orders, i.e. orders G0056500 and G0064108 don't belong to item 1007. So i need select manually, but in real data base there are many orders, and to select them manually it's so annoying. Below i put a video with a final result that i need. 

v-haibl-msft
Microsoft Employee

@AntanasK

 

It seems that your video is unavailable, could you please upload it again?

 

Best Regards,
Herbert

AntanasK
Advocate I

Sorry, my bad, now it seems available. 

v-haibl-msft
Microsoft Employee

@AntanasK

 

Thanks for your video. I’ve reported it internally to Power BI Team: CRI 40631969
I’ll post here once I get any update about it.

 

Best Regards,
Herbert

Vicky_Song
Impactful Individual
Status changed to: Accepted