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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

0

Slicers function "Select all" weirdness

Hi everyone,

just got an interesting weirdness of standart power bi slicer. Lets say you have i.e. two slicers (items and orders). Select one item no.1007, then in another slicer you can see filtered all belonging orders. Because there are a lot of orders and you dont want to select them manualy so im using "select all". So far so good, but next when i deselect item, slicer with orders understand that i want select whole orders instead of belonging orders to item no.1007. Hows that? Why?
I tried custom visual "hierarchy slicer", and that slicer helped me in one side, because his "select all" not select whole units, but in another side there is a 4K row limit. So... i'm stuck. Any ideas?

Antanas 

Status: Delivered
Comments
v-qiuyu-msft
Community Support

Hi @AntanasK,

 

The issue has been reported before internally: CRI 23743458. 

 

This is by design, we store previous selections and show them regardless of whether another filter may hide them. We do not want to clear selections based on filter from other slicers, and we are obligated to show any seleted items.

 

Best Regards,
Qiuyun Yu

Vicky_Song
Impactful Individual
Status changed to: Delivered
 
AntanasK
Frequent Visitor

First, want to thank you for your answer and request to responsible persons. So, as i understood, now i need to wait for solution of MS specialist (of course if they decided to solve this problem). 

Also, i asked "hierarchy slicer" author, if there is a possibility to remove 4K row limit, but still waiting for answer. So, in your opinion, that "select all" fuctionality. that hierarchy slicer has, is hard to install to standard slicer? 

 

Regards,

Antanas

v-qiuyu-msft
Community Support

Hi @AntanasK,

 

We can use "Select All" to select all values in current slicer visual. But in your specific scenario, "Select all" is working as you got.

 

Best Regards,
Qiuyun Yu

AntanasK
Frequent Visitor

That's the aswer of power bi team in request CRI 23743458

v-qiuyu-msft
Community Support

Hi @AntanasK,

 

Nope. It's my opinion. 

 

Best Regards,
Qiuyun Yu 

AntanasK
Frequent Visitor

Still no answer? 😞 don't know how to solve, my partner waiting for dashboard and i can't give him to use. Strange that nobody stucked in the same situation... 

v-qiuyu-msft
Community Support

Hi @AntanasK,

 

I will double confirm this from PG team internally. Before that, I would double confirm from you the issue you want to report.

 

The sample data below, create two slicer visuals:

w1.PNGw2.PNG

select "no.1007" in left slicer, the right slicer filtered with value 1,3,5

 

w3.PNG

Then select the "Select All" option in right slicer, deselect the "no.1007" in left slicer, all values display in right slicer(1,2,3,4,5,6). What you want is to show value for no.1008 in right slicer(2,4,6), right?

 

w4.PNGw5.PNG

Best Regards,
Qiuyun Yu

AntanasK
Frequent Visitor

When deselect item no.1007 want that slicer with orders keep showing selected orders no. 1-3-5 instead of selecting whole orders. Below recorded a video.

 

v-qiuyu-msft
Community Support

Hi @AntanasK,

 

I understand what you want. I have sent a email to consult this internally, will update here once I get information. 

 

Best Regards,
Qiuyun Yu