March 25, 2015 at 3:54 am
Hi Guys,
Is it possible to have a All members attribute displayed in an Excel slicer?
For instance if I have Product dimension, it would look something like:
Product A, Product B, Product C, All Products?
All Products would show aggregations for Product A, Product B, and Product C.
Is there a workaround for this?
Thanks in advance.
Jon
March 25, 2015 at 5:46 am
If you have a slicer for products, then by default all products are selected which is the same as the ALL member.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 25, 2015 at 5:49 am
Hi Koen,
Yes, but is it possible to have All Products as another member in the slicer which aggregates all values? Just like there is Product A etc?
March 25, 2015 at 5:50 am
Jonathan Mallia (3/25/2015)
Hi Koen,Yes, but is it possible to have All Products as another member in the slicer which aggregates all values? Just like there is Product A etc?
Wouldn't that make Excel double count everything when the slicer has by default everything selected?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 25, 2015 at 5:54 am
Yes, you have a point, since you cant (as yet) force excel to have 1 value selected at a time.
But I was wondering if it is achievable in any way?
March 25, 2015 at 1:21 pm
I did some research, but I can't currently find a way to show the ALL member in a slicer.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 26, 2015 at 1:48 am
Hi Koen thanks for this. Let us know if you find something interesting 🙂
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply