Numeric-Slicer Count

[Rene83]

Hello.
I would like to implement the following.

I have a table with about 20 columns and about 2 million rows.
Currently there is always a filter set via
"Filter for this page" - "Is greater or equal than" - "50". As value field the column "Type" is taken which contains a text.

However, I would like to filter the number dynamically via a numeric slicer.
Similar to filtering a time period.

Thanks
Rene

[Anonymous]

Hi @Rene83 

Put the measure in Filters on all pages in Filters .

Best Regard

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Rene83]

Hi @Anonymous ,

measure cannot be added in Filters on all pages.

This works only with columns.

Is there any solution here?

Best Regard

Rene

[Anonymous]

Hi @Rene83 

I created a sample. Filter the numbers in the data table through the number category in the slicer, and you can see if it meets your needs.

(1)Create a slicer table with number category .

(2)Then create a measure to judge whether the data in data table match the selected value in slicer .

Flag =
VAR _sum =
    CALCULATE (SUM ( 'Table'[value]), ALLEXCEPT ( 'Table', 'Table'[Product] ))
RETURN
    SWITCH (MAX ( Slicer[category] ),
        "10+", IF ( _sum > 10, 1 ),
        "30+", IF ( _sum > 30, 1 ),
        "50+", IF ( _sum > 50, 1 ),
        "100+", IF ( _sum > 100, 1 ),
        "All", 1)

(3)Add the measure in data visual and set the measure is equal 1

The final result is as shown :

I have attached my pbix file , you can refer to it .

Best Regard

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Rene83]

Hi @Anonymous ,

thank you for your solution. Works very well. I still have one question. How can I use the measure "Flag" as a filter on all pages?

Best Regrad

Rene

[AllisonKennedy]

@Rene83 Can you paste the first few rows of the columns you want to use in the slicer and show screenshot of your page level filter. I'm not sure what you mean as you mention both text and number so need to know a bit more about the data