Forum Discussion

bonjourposte's avatar
bonjourposte
Helper V
2 years ago
Solved

Filter for two separate tables

This is probably easy, but I can't find the solution.  I'm trying to create a filter that I can click on to show me everything that is conditional formatted in my table.  I have two colours- green and yellow.  The problem is, they come from two separate tables in power query.  I want a button that users can click on to show them all the green lines (which will filter the table and thus the map beside it), and then another button that will show them all the yellow lines in the table.  (I already have a button to reset all filters).  

 

 

Thanks!

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi bonjourposte 

     

    Perhaps the following can help.

     

    My sample:

     

    Then I created conditional formatting for it.

     

    Place the measure in the filter so that the visualization will only show data with a green color.

    Then add Bookmark for this state.

     

    Create a blank button, and set it up as shown here. Set the type to Bookmark, and point it to the corresponding Bookmark.

     

    You can also directly set the Bookmark type button.

     

    Setting the yellow button does the same thing.

     

    Result:

     

     

    Best Regards,
    Yulia Xu

     

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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi bonjourposte 

     

    Perhaps the following can help.

     

    My sample:

     

    Then I created conditional formatting for it.

     

    Place the measure in the filter so that the visualization will only show data with a green color.

    Then add Bookmark for this state.

     

    Create a blank button, and set it up as shown here. Set the type to Bookmark, and point it to the corresponding Bookmark.

     

    You can also directly set the Bookmark type button.

     

    Setting the yellow button does the same thing.

     

    Result:

     

     

    Best Regards,
    Yulia Xu

     

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

    • bonjourposte's avatar
      bonjourposte
      Helper V
      2 years ago

      Thanks so much, Yulia.  I did a version of this.  Because my columns were in two separate tables, I made two separate slicers:

       

       

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    Hi bonjourposte 

    Please create a sample pbix file with sample data (the model and table patter should match with your existing report) and share the PBIX file link (Google Drive, Dropbox, onedrive etc)
    Do not forget to explain the expected result based on the sample data. Make sure that your explanation is referencing column names used in the sample data.

    How to get your answer quickly - https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

    How to provide sample data in the Power BI Forum  - https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

     


    Let me know if that works for you


    If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

    Thanks
    Pijush
    Linkedin