Add a slider for a count of value

[Anonymous]

I want to add a slicer to filter all the visuals on one page of my Power BI report by the count of 'order number' so I'm only seeing data where there has been greater than 5 or 10 orders for example. 

Is there a way I can do this?

[v-yalanwu-msft · Accepted solution]

Hi, @Anonymous ;

You could create a flag measure , and apply it in another visuals.like below:

1. create a slicer table.

slicer = GENERATESERIES(1, 20, 1)

2.create a flag measure.

flag = IF(CALCULATE(COUNT([order number]),ALLEXCEPT('Table','Table'[order number]))>=SELECTEDVALUE(slicer[slicer]),1,0)

3.apply it into every visual.

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

"where there has been greater than 5 or 10 orders"

Per what? Per customer? Per day?  Per store?

[Anonymous]

@lbendlin per item (part) 

[lbendlin]

Create a measure that uses table variables to collect the base data (with ADDCOLUMNS) and then filters it down as needed. As a last step use COUNTROWS() on the last table variable to get the measure result.

Use CONCATENATEX along the way to validate each intermediate step.