Pivot table filter value with greater than x slicer

[ma.har]

Hi all,



I have a somewhat large table (close to 1M rows) that I'm trying to analyze using a Pivot Table. The rows section shows me the customer ID and the values are the project volume amongst other things. I created a really nice looking interactive dashboard and i was was wondering if it was possible to use slicers to filter a pivot table by any of the value filters?



My first approach was the following:

I created a helper table on another sheet, which simply contains a series of values (starting from 0 to 500k in 100k steps) and a name. The value names are simply used for the slicer for aesthetic reasons. For the helper table I created a slicer so that I can filter the values.

Then I created a measure in the actual customer table, which gives me the MIN value from the helper table

and a second measure that only shows values if greater than the MIN

Two problems with this approach:
1. the MIN function shows me the MIN value of the helper table not only for the visible values (even if it is filtered, the MIN value remains 0)

2. the actual table does not react and does not update itself from the helper table after using the silcer

Can anyone tell me if this is generally possible? Where is my thinking error? Is there possibly a smarter approach to reach the goal?


I am grateful for any advice

[Pepe Le Mokko]

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

[ma.har]

Hi,


Thank you very much for your answer.



I have attached a sample file that shows my basic problem. Again I try to use the table below to create a way to filter the projects in the actual table using the silcer.*



Please give me feedback if something is not clear. I hope for some advice.*



Thanks and best regards

[JeteMc]

Hello ma.har and Welcome to Excel Forum.
The tutorial linked below may describe what you are looking for.
https://powerpivotpro.com/2011/09/gu...tween-slicers/

[ma.har]

Hello ma.har and Welcome to Excel Forum.
The tutorial linked below may describe what you are looking for.

Hi JeteMC,

I completely agree with you! This is exactly what I tried to do at the beginning, but it led to the problem mentioned above.

-> the MIN function in the DAX formula shows me not only the MIN value of the filtered (visible) values but of the total existing values in this table (the result is therefore always the smallest existing value ->0)

Do you have a solution to this? The attached sample file allows you to recreate my problem.


Thank you and best regards

[JeteMc]

the MIN function in the DAX formula shows me not only the MIN value of the filtered (visible) values but of the total existing values in this table

I ran across something that made me think about how this might be done.
This video tutorial talks about that DAX Calculate function which should allow you to filter.
https://www.youtube.com/watch?time_c...ature=emb_logo
Let us know if you have any questions.