Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
1 year ago

Help applying custom filter with Parameter

I have a table with many fields including 2 that I want to filter:

order_time_YYYYMMDD and job_name

The thing is, I want to create a table that filters by order_time_YYYYMMDD. To perform this filter I use a slice as a parameter that goes from 0 to 20.

In this way the user modifies that slice, and with a measure we calculate the feha subtracting from today as many days as come in that slice. This tells us the date filter that I have to look for in the table.

So far so good but I am not able to generate a visual table that only takes that data for me. Keep in mind that you will have many jobnames with the same order_time_YYYYMMDD

Does anyone know how to do it?

Thank you!

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Syndicate_Admin 


    Please provide sample data that fully covers your issue (in the form of table or pbix file) and the expected outcome based on the sample data you provided. Please remove any sensitive data in advance.

     

     

     

    Best Regards,

    Jayleny

     

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