Forum Discussion

AxelKAp's avatar
AxelKAp
Helper I
3 years ago

Create a threshold filter

Hi everyone,  I have a table where all the invoice lines are stored, you can find the following columns:  - Invoice number, Invoice Line, invoice date, entity, country, supplier name, amount in €...
Need Help
AxelKAp's avatar
AxelKAp
Helper I
3 years ago

Hi MAwwad , 

Thanks for you reply ! 
For the table thresholds, I have created this table because I didn't have this table before:

And for the below thresholds I have this formula:

But I don't see how I can filter with this formula, because when I create a slicer view I can not add the formula.
And second question, how this formula can help to filter the suppliers thresholds ? 

Thanks for your time

 

MAwwad's avatar
MAwwad
Solution Sage
3 years ago

In the Filter Slicer, Use the Column you created that contains the threshhold 

  • AxelKAp's avatar
    AxelKAp
    Helper I
    3 years ago

    It's not working, when I take the column Thresholds in the Thresholds table and I filter nothing happen

    • MAwwad's avatar
      MAwwad
      Solution Sage
      3 years ago

      Send a copy PBIX 

      • AxelKAp's avatar
        AxelKAp
        Helper I
        3 years ago

        I didn't succeed to share the PBIX.
        But I can share with you the test table:
        Invoice NumberInvoice DateInvoice AmountSupplier Name

        A123samedi 1 janvier 2022570 000 €Supplier A
        B123samedi 1 janvier 202220 000 €Supplier B
        C123samedi 1 janvier 2022123 000 €Supplier C
        D123samedi 1 janvier 202280 000 €Supplier D

        But here it's only a few lines, I have more than 10M of lines.