Filter for two separate tables

[bonjourposte]

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!

[Anonymous · Accepted solution]

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]

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

[PijushRoy]

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/1447...

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-...

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