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

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