rileybloke
New Member
- Joined
- Feb 7, 2013
- Messages
- 43
Hi,
I have a powerpivot table showing quantities for items across a time dimension.
I have a calculated measure that counts if a quantity for a given time falls below zero. (FallBelowZero)
I am publishing this book onto sharepoint and would like to give the end user a slicer 1. Fall Below Zero or 2. Normal
If they click 1. Fall Below Zero, then the table is filtered to only show those items which have a quantity that falls below zero.
The above is instead of selecting the column filter for the ITEM, and filtering it on the measure.
I have created a seperate unlinked table for the slicer 1. or 2. but how can I link a filter to the slicer?
Thanks
Riley
I have a powerpivot table showing quantities for items across a time dimension.
I have a calculated measure that counts if a quantity for a given time falls below zero. (FallBelowZero)
I am publishing this book onto sharepoint and would like to give the end user a slicer 1. Fall Below Zero or 2. Normal
If they click 1. Fall Below Zero, then the table is filtered to only show those items which have a quantity that falls below zero.
The above is instead of selecting the column filter for the ITEM, and filtering it on the measure.
I have created a seperate unlinked table for the slicer 1. or 2. but how can I link a filter to the slicer?
Thanks
Riley