Forum Discussion

Heinrich's avatar
Heinrich
Post Partisan
3 years ago
Solved

Filter Data

Hello   I would like that some data react as filter would that be possible. The goal is when I press on the button then the data is shown on a separate field   Thank you for your help   ...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Heinrich ,

     

    According to your description, here are my steps you can follow as a solution.

    (1) This is my test data.  

    (2) We can create two tables.

    Table = SUMMARIZE('MS Teams Incidents','MS Teams Incidents'[Ticket Number],'MS Teams Incidents'[Escalated])
    Table 2 = FILTER('Table','Table'[Escalated]="false")

    (3) Then the result is as follows.

     

    If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

     

    Best Regards,

    Neeko Tang

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

Heinrich's avatar
Heinrich
Post Partisan
3 years ago

Hi DataSlayer
Thank you.

 

How does the formula look like if I want to filter the data of:

 

Show me all data that have been escalated or reassigned more than x times.

Is the bottom needed can it be behind the the text or a number so as invisible. Once I klick on the visible field it is shown.

 

Thank you

 

Heinrich