Filtering an entire page based on < or > greater than values

[Anonymous]

Hi Everyone   -  I am trying to do something fairly simple, but can't find a solution.  

This report features values based on order values.   I need for my users tobe able to easily filter ALL of the visuals at once by just selecting one of 3 options:   Orders above 75k.    Orders below 75k.    Select All.     Ideally this would be a slicer at the top of the page and by just clicking on one of the options, all of the visuals will filter to reflect whatever choice is made.  

I've also thought about creating a bookmark, but the top row of visuals do not filter unless something in the tables below is selected.    

Any ideas?   

[Anonymous]

is [# of order] measure?

If yes.

then create one table without relationship which contains values >75,<75,ALL

add it it slicer and make it single select.

Create measure

measure=switch(true(),selectevalue(dummy[slicer])=">75",if([ordrs]>75,1,0),

selectevalue(dummy[slicer])="<75",if([ordrs]<75,1,0),selectevalue(dummy[slicer])="All",1)

add this measure to all visual level filters and set it to is not 0.

if orders is column then modify above measures if part that is

Sumx(table,table[order]>75,1,0) instead of if([ordrs]>75,1,0)

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

[Anonymous]

Ok, so I figured out the table.

And here is the measure I created.

Slicer Measure = SWITCH(true(),selectedvalue('Backlog Slicer'[Value])="= > 75",if([Backlog Total]>75,1,0), selectedvalue('Backlog Slicer'[Value])="< 75",if([Backlog Total]<75,1,0),selectedvalue('Backlog Slicer'[Value])="All",1)

But when I add it to the visual filter, it does not allow me to select anything.  I cannot sort by any particular value.   

[Anonymous]

Thank you...one quick question.  

The values are not static, they change every day (hour).   Would I create a calculated table?  

[Anonymous]

why do you want to create calculated table?

if orders are changing per hour the above solution will work fine for you.

and one thing about calculated tables is they are get loaded at first load only. Calculated table values will not change dynamically.

[Anonymous]

Hi,

Sorry, I am not clear on how to create a table with these values.  

The value comes from one column....Order Value.   Then I have  created seperate measures for < 75k   or  >  75k.    Not sure how to put that into a table?

[Anonymous]

Go to Home ribbon

Click on enter data

add three rows

1 >75

2 <75

3 all

rename table to dummy and column name to slicer.

and then write above measure which i have suggested.

What is order value in your dataset(Measure/Column)

I have provided solution for both cases.

Please modify above measure as your dataset 

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

[Anonymous]

It is a measure. 

Backlog Total = SUM(Orders[Net Price])

When I put the new slicer measure into the visual filter area, for any filter, it does not give me the option to select any values.