Forum Discussion

Rene83's avatar
Rene83
Frequent Visitor
4 years ago

Numeric-Slicer Count

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

Need Help

5 Replies

  • AllisonKennedy's avatar
    AllisonKennedy
    Community Champion
    4 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      Rene83
      Frequent Visitor
      4 years ago

      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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      Rene83
      Frequent Visitor
      4 years ago

      Hi Anonymous ,

       

      measure cannot be added in Filters on all pages.

      This works only with columns.

      Is there any solution here?

       

      Best Regard

      Rene